How can I kill all my postgresql connections? I'm trying a rake db:drop but I get: ERROR: database "database_name" is being accessed by other users DETAIL: There are 1 other session(s) using the database. I've tried shutting down the processes I see from a ps -ef | grep postgres but this doesn't work either: kill: kill 2358 failed: operation not permitted

When I was not using Angular 4, I would just put the script tags for the library. Even when I put the script tags in the index.html file it is not recognizing CryptoJS. Is there a way to use the library or a Angular equivalent?

I was able to overwrite any keyboard shortcut from VS Code just by adding a new key in the keybindings.json file. However I can't remove an existing shortcut. More specifically, I'd like to remove this one: { "key": "ctrl+alt+down", "command": "editor.action.insertCursorBelow", "when": "editorTextFocus" } Any ideas on how I can remove it?

Yes, you can. Having now gone down this path: yes, it is possible to set up an SSH tunnel from heroku to an external database. [NOTE: My particular app was written in Ruby on Rails, but the solution given here should work for any language hosted on Heroku.] Statement of the problem I am running an app on Heroku. The app needs to access an external MySQL database (hosted on AWS) from which it grabs

Ok, so I got it working as follows. I have Ubuntu on windows, with anaconda python 3.6 installed. Download and install VcXsrv or Xming (X11 for Windows) from sourceforge(see edit below) sudo apt-get update sudo apt-get install python3.6-tk (you may have to install a different python*-tk depnding on the python version you're using) pip install matplotlib (for matplotlib. but many other things now w

I am using d3.js for graph. at some point i have to show data with some special part of graph for example if the values is cross some boundary then show that part with filling pattern. for more clear is there in and image. i get the rect part that cross the boundary but how can i fill it with this pattern? any css or canvas tricks? Note : this image is just an example not the real one

While other questions deal with how to use things like git-bash, giving the new WSL a spin as the terminal for VS Code is not the same: it gives you access to bash running on an actual Ubuntu Linux subsystem, instead of the git-bash terminal running on the Windows subsystem. So how do we get it working as the VS Code terminal, and particularly how do we get it working as a functional dev environme

When running pod repo update the following error is generated: Updating spec repo `master` [!] Failed to connect to GitHub to update the CocoaPods/Specs specs repo - Please check if you are offline, or that GitHub is down Using cocoapods 1.0.1 I'm also aware of this: Master spec-repo rate limiting post‑mortem. Adding --verbose flag to the call shows the ruby call stack: .rvm/gems/ruby-2.3.0/gems/c

I've done quite some research, but I'm not totally satisfied with what I found. Just to be sure here's my question: What is actually the most robust and elegant automated solution for deserializing JSON to TypeScript runtime class instances? Say I got this class: class Foo { name: string; GetName(): string { return this.name }; } And say I got this JSON string for deserialization: {"name": "John D

The format of a line from /proc/net/ip_conntrack is the same as for /proc/net/nf_conntrack, except the first two columns are missing. I'll try to summarize the format of the latter file, as I understand it from the net/netfilter/nf_conntrack_standalone.c, net/netfilter/nf_conntrack_acct.c and the net/netfilter/nf_conntrack_proto_*.c kernel source files. The term layer refers to the OSI protocol la

I'm trying to download a file from S3 bucket. The link of the URL is a presigned url. I can able to download the S3 link via web browser but unfortunately it doesn't apply for the linux terminals. Below is the sample link. https://prod-04-2014-tasks.s3.amazonaws.com/snapshots/054217445839/rk12345-414a7069-c29e-42b7-8c46-2772ef0f572d?X-Amz-Security-Token=FQoDYXdzELz%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEa

In my script I have: openssl req \ -x509 \ -new \ -nodes \ -key certs/ca/my-root-ca.key.pem \ -days 3652 \ -out certs/ca/my-root-ca.crt.pem \ -subj "/C=GB/ST=someplace/L=Provo/O=Achme/CN=${FQDN}" Running this on Windows in Git Bash 3.1 gives: Subject does not start with '/'. Tried escaping the subj like so: -subj \"/C=UK/ST=someplace/L=Provo/O=Achme/CN=${FQDN}\" Still doesn't work. Any ideas?

While putting below JSON in dynamo DB using AWS CLI with below command: aws dynamodb put-item --table-name ScreenList --item file://tableName.json I am getting Parameter validation failed Exception.I have gone rigorously through AWS docs but failed to find example to insert a complicated json.Every small help is welcome. The updated Json : { "itemName": { "S": "SCREEN_LIST" }, "productName": { "S"

It sure is. The server: #!/usr/bin/python import json from bottle import route, run, request, abort, Bottle ,static_file from pymongo import Connection from gevent import monkey; monkey.patch_all() from time import sleep app = Bottle() @app.route('/websocket') def handle_websocket(): wsock = request.environ.get('wsgi.websocket') if not wsock: abort(400, 'Expected WebSocket request.') while True: t

My daughters have made a game not unlike tic-tac-toe. Of course as I played it with them I started brute-forcing it in my head... So at lunchtime I made a quick little Python script to 'solve' the game. And I wanted to see the results graphically, so I generated a dot file of all legal moves: I've pasted the data here. When I try and render it using dot, it takes forever and I abort it after a few

I want to create a list of dates, starting with today, and going back an arbitrary number of days, say, in my example 100 days. Is there a better way to do it than this? import datetime a = datetime.datetime.today() numdays = 100 dateList = [] for x in range (0, numdays): dateList.append(a - datetime.timedelta(days = x)) print dateList

Moderator note: Please resist the urge to edit the code or remove this notice. The pattern of whitespace may be part of the question and therefore should not be tampered with unnecessarily. If you are in the "whitespace is insignificant" camp, you should be able to accept the code as is. Is it ever possible that (a== 1 && a ==2 && a==3) could evaluate to true in JavaScript? This is an interview qu

iostat -x -d can display many i/o statistic info. For util of iostat, the explanation is : Percentage of CPU time during which I/O requests were issued to the device (band-width utilization for the device). Device saturation occurs when this value is close to 100% I want to know how the util was computed? I make an experiment, (see following code), start 40 thread to randomly read 40 files. I supp

I have the following in a migration: create_table :model_with_a_long_name do |t| t.references :other_model_with_an_equally_long_name, index: true end That produces an index with too long of a name for Postgres. Is there a way to manually specify the index name (without adding the integer column and the index separately)? Something like the following: create_table :model_with_a_long_name do |t| t.r

Running Rails 4.2.0 so I am using the ActiveJob w/ Sidekiq backend. I need to invoke regularly scheduled background jobs so I am hoping to use Clockwork, but I haven't seen any examples of how to use it with ActiveJob. Here is my lib/clock.rb based off the Clockwork Github example: require 'activejob' module Clockwork handler do |job, time| puts "Running #{job}, at #{time}" ProductUpdateJob.perfor