I got this issue as well after running `brew upgrade`. Following commands worked for me:

    brew uninstall postgresql
    brew install postgresql@9.6
    brew services start postgresql@9.6
    brew link postgresql@9.6 --force


I&#39;m working on a codebase that uses Spacy. I installed spacy using:

    sudo pip3 install spacy

and then 

    sudo python3 -m spacy download en

At the end of this last command, I got a message:

        Linking successful
    /home/rayabhik/.local/lib/python3.5/site-packages/en_core_web_sm --&gt;
    /home/rayabhik/.local/lib/python3.5/site-packages/spacy/data/en

    You can now load the model via spacy.load(&#39;en&#39;)

Now, when I try running my code, on the line:

        from spacy.en import English
it gives me the following error:

    ImportError: No module named &#39;spacy.en&#39;

I&#39;ve looked on Stackexchange and the closest is:  https://stackoverflow.com/questions/34842052/import-error-with-spacy-no-module-named-en
which does not solve my problem.

Any help would be appreciated. Thanks.

Edit: I might have solved this by doing the following:

   

     Python 3.5.2 (default, Sep 14 2017, 22:51:06) 
    [GCC 5.4.0 20160609] on linux
    Type &quot;help&quot;, &quot;copyright&quot;, &quot;credits&quot; or &quot;license&quot; for more information.
    &gt;&gt;&gt; import spacy
    &gt;&gt;&gt; spacy.load(&#39;en&#39;)
    &lt;spacy.lang.en.English object at 0x7ff414e1e0b8&gt;

and then using:

    from spacy.lang.en import English

I&#39;m still keeping this open in case there are any other answers.



ImportError: No module named &#39;spacy.en&#39;

I am trying to find the coverage using coverage module for a django project but gets 
```
Coverage.py warning: No data was collected. (no-data-collected)
```
My project folder has src and tests folders.

When I run 
```
coverage run -m pytest &amp;&amp; coverage report
```
It produces a report with 100% coverage with the list of files inside the tests folder.
Whereas when I run
```
coverage run --source=src -m pytest &amp;&amp; coverage report
```
it says 
```
Coverage.py warning: No data was collected. (no-data-collected)
No data to report.
```
When I try to give the `source=src` or `include=src` in the `.coveragerc` also the same warning occurs. The tests passes for all the above cases.

I want the coverage of the src folder.
Is it because I am missing some path setting?

Coverage.py warning: No data was collected. (no-data-collected)

My mac has postgresql 10.1 on it, and I need 9.6 for my work website to function on my local machine.  Can&#39;t find easy instructions on how to uninstall or downgrade to 9.6. Any help would be appreciated! 

How to use homebrew to downgrade postgresql from 10.1 to 9.6 on Mac OS

<p>My mac has postgresql 10.1 on it, and I need 9.6 for my work website to function on my local machine.  Can't find easy instructions on how to uninstall or downgrade to 9.6. Any help would be appreciated!</p>


Is it possible to install only mysqldump on macOS without MySQL itself.

I&#39;m using MySQL db via Docker, but can&#39;t dump the DB from my local machine via MySQL Workbench.

&gt; /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump is version
&gt; 5.7.17, but the MySQL Server to be dumped has version 5.7.20.

Do you have any suggestions on how to fix that and be able to make dumps from my local machine.

Is it possible to install only mysqldump on macOS

I am trying to set up my ssh config on the Mac (Mac OS Sierra 10.12.6) in such a way that it stores the passphrase for my ssh key in the keychain. Previously I could do that with

    ssh-add -K ~/.ssh/id_rsa

But recently this doesn&#39;t seem to work anymore. Following [this article][1] there seems to be a change in the behaviour of the ssh config in Mac OS &gt; 10.12.2 and the recommended way to fix this issue is to add `UseKeychain yes` to your ssh config. So here&#39;s my `.ssh/config` section the `Host *`:

    Host *
      Port 22
      ServerAliveInterval 60
      ForwardAgent yes
      IdentityFile ~/.ssh/id_rsa
      AddKeysToAgent yes
      UseKeychain yes

When trying to ssh to a foreign host, I get the following error message:

    $ ssh my-host
    /Users/USER/.ssh/config: line 16: Bad configuration option: usekeychain

Any ideas why this happens and how I can fix it? Thanks!

  [1]: https://developer.apple.com/library/content/technotes/tn2449/_index.html

.ssh/config: &quot;Bad configuration option: UseKeychain&quot; on Mac OS Sierra 10.12.6

**Problem**: adb start-server fails.

    --- adb starting (pid 1414) ---
    adb I 12-05 17:28:30  1414 48453 main.cpp:57] Android Debug Bridge version 1.0.39
    adb I 12-05 17:28:30  1414 48453 main.cpp:57] Version 27.0.0-4455170
    adb I 12-05 17:28:30  1414 48453 main.cpp:57] Installed as /Users/[username]/Library/Android/sdk/platform-tools/adb
    adb I 12-05 17:28:30  1414 48453 main.cpp:57] 
    adb I 12-05 17:28:30  1414 48453 adb_auth_host.cpp:416] 
    adb_auth_init...
    adb I 12-05 17:28:30  1414 48453 adb_auth_host.cpp:174] read_key_file &#39;/Users/[username]/.android/adbkey&#39;...
    adb F 12-05 17:28:30  1414 48466 transport_usb.cpp:37] Check failed: usb_packet_size &lt; 4096ULL (usb_packet_size=5120, 4096ULL=4096) 

**Catalyst**: Installing platform tools v27.0.0

**Solutions Tried**: Restarting Android Studio, Restarting computer, Manually starting ADB via terminal, deleting /Users/[username]/.android/adbkey and adbkey.pub, and reinstalling platform tools

Also I am not using genymotion, just the stock emulator.

Android Studio - ADB start server fails, adbkey check fails

Hi I&#39;m trying to see the status of my apache services on my Mac. I tried the command 

    sudo service httpd status

but command not found

I look up in Google and discover `systemctl` so I try that

    sudo man systemctl

and it shows no manual entry for `systemctl`

I noticed that I didn&#39;t see much mac os and only see linux in the websites on Google.

Does the command `systemctl` and `service` exists on linux only and not Mac?

If so, what is the mac version of these command?


Does the command systemctl and service exists on linux only and not mac?

i found this error when trying to run mongodb. I install it via homebrew. Please assist

    Agungs-MacBook-Pro:~ agungmahaputra$ mongod
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] MongoDB starting : pid=5189 port=27017 dbpath=/data/db 64-bit host=Agungs-MacBook-Pro.local
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] db version v3.6.0
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] git version: a57d8e71e6998a2d0afde7edc11bd23e5661c915
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] OpenSSL version: OpenSSL 1.0.2n  7 Dec 2017
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] allocator: system
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] modules: none
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] build environment:
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten]     distarch: x86_64
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten]     target_arch: x86_64
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] options: {}
    2017-12-26T15:31:15.911+0700 E STORAGE  [initandlisten] Failed to set up listener: SocketException: Address already in use
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] now exiting
    2017-12-26T15:31:15.911+0700 I CONTROL  [initandlisten] shutting down with code:48
    Agungs-MacBook-Pro:~ agungmahaputra$



SocketException: Address already in use MONGODB

I&#39;ve been doing the Rails tutorial found [here][1] and have been successful up to the point of having to migrate the Comments migration using **$ rails db:migrate**. Prior to this point, I&#39;ve been able to generate the Article model and migrate the Articles create migration with no issues. In between these two migrations, nothing has changed in my Gemfile, so I&#39;m not sure what it is Bundler is having an issue with. 

Here are the errors, followed by the full command-line output, along with my Gemfile and schema.rb:

    Gem::LoadError: can&#39;t activate pg (~&gt; 0.18), already activated pg-1.0.0.
    
    Gem::LoadError: Specified &#39;postgresql&#39; for database adapter, but the gem is not loaded. Add `gem &#39;pg&#39;` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord).

**Full command-line output**

    xxx:gangelo: ~/dev/rails/test/blog (master*) ☠  rbenv exec rails db:migrate
    rails aborted!
    Gem::LoadError: Specified &#39;postgresql&#39; for database adapter, but the gem is not loaded. Add `gem &#39;pg&#39;` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord).
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/connection_specification.rb:188:in `rescue in spec&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/connection_specification.rb:185:in `spec&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:880:in `establish_connection&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_handling.rb:58:in `establish_connection&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/railtie.rb:124:in `block (2 levels) in &lt;class:Railtie&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:69:in `instance_eval&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:69:in `block in execute_hook&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:60:in `with_execution_control&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:65:in `execute_hook&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:50:in `block in run_load_hooks&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:49:in `each&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:49:in `run_load_hooks&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/base.rb:326:in `&lt;module:ActiveRecord&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/base.rb:25:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `block in require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/mysql_database_tasks.rb:6:in `&lt;class:MySQLDatabaseTasks&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/mysql_database_tasks.rb:3:in `&lt;module:Tasks&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/mysql_database_tasks.rb:2:in `&lt;module:ActiveRecord&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/mysql_database_tasks.rb:1:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `block in require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:74:in `&lt;module:DatabaseTasks&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:35:in `&lt;module:Tasks&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:2:in `&lt;module:ActiveRecord&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:1:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `block in require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/railtie.rb:34:in `block (3 levels) in &lt;class:Railtie&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/railties-5.1.4/lib/rails/commands/rake/rake_command.rb:21:in `block in perform&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/railties-5.1.4/lib/rails/commands/rake/rake_command.rb:18:in `perform&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/railties-5.1.4/lib/rails/command.rb:46:in `invoke&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/railties-5.1.4/lib/rails/commands.rb:16:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/bin/rails:9:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/bin/rails:9:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/client/rails.rb:28:in `load&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/client/rails.rb:28:in `call&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/client/command.rb:7:in `call&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/client.rb:30:in `run&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/bin/spring:49:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/binstub.rb:31:in `load&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/binstub.rb:31:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/bin/spring:15:in `&lt;top (required)&gt;&#39;
    bin/rails:3:in `load&#39;
    bin/rails:3:in `&lt;main&gt;&#39;
    
    Caused by:
    Gem::LoadError: can&#39;t activate pg (~&gt; 0.18), already activated pg-1.0.0. Make sure all dependencies are added to Gemfile.
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql_adapter.rb:2:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `block in require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/connection_specification.rb:186:in `spec&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:880:in `establish_connection&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/connection_handling.rb:58:in `establish_connection&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/railtie.rb:124:in `block (2 levels) in &lt;class:Railtie&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:69:in `instance_eval&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:69:in `block in execute_hook&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:60:in `with_execution_control&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:65:in `execute_hook&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:50:in `block in run_load_hooks&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:49:in `each&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/lazy_load_hooks.rb:49:in `run_load_hooks&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/base.rb:326:in `&lt;module:ActiveRecord&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/base.rb:25:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `block in require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/mysql_database_tasks.rb:6:in `&lt;class:MySQLDatabaseTasks&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/mysql_database_tasks.rb:3:in `&lt;module:Tasks&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/mysql_database_tasks.rb:2:in `&lt;module:ActiveRecord&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/mysql_database_tasks.rb:1:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `block in require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:74:in `&lt;module:DatabaseTasks&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:35:in `&lt;module:Tasks&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:2:in `&lt;module:ActiveRecord&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:1:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `block in require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:292:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/activerecord-5.1.4/lib/active_record/railtie.rb:34:in `block (3 levels) in &lt;class:Railtie&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/railties-5.1.4/lib/rails/commands/rake/rake_command.rb:21:in `block in perform&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/railties-5.1.4/lib/rails/commands/rake/rake_command.rb:18:in `perform&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/railties-5.1.4/lib/rails/command.rb:46:in `invoke&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/railties-5.1.4/lib/rails/commands.rb:16:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/bin/rails:9:in `require&#39;
    /Users/gangelo/dev/rails/test/blog/bin/rails:9:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/client/rails.rb:28:in `load&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/client/rails.rb:28:in `call&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/client/command.rb:7:in `call&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/client.rb:30:in `run&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/bin/spring:49:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/binstub.rb:31:in `load&#39;
    /Users/gangelo/dev/rails/test/blog/vendor/bundle/gems/spring-2.0.2/lib/spring/binstub.rb:31:in `&lt;top (required)&gt;&#39;
    /Users/gangelo/dev/rails/test/blog/bin/spring:15:in `&lt;top (required)&gt;&#39;
    bin/rails:3:in `load&#39;
    bin/rails:3:in `&lt;main&gt;&#39;
    Tasks: TOP =&gt; db:migrate =&gt; db:load_config
    (See full trace by running task with --trace)

**Gemfile**

    source &#39;https://rubygems.org&#39;
    
    ruby &#39;2.3.1&#39;
    
    git_source(:github) do |repo_name|
      repo_name = &quot;#{repo_name}/#{repo_name}&quot; unless repo_name.include?(&quot;/&quot;)
      &quot;https://github.com/#{repo_name}.git&quot;
    end
    
    
    # Bundle edge Rails instead: gem &#39;rails&#39;, github: &#39;rails/rails&#39;
    gem &#39;rails&#39;, &#39;~&gt; 5.1.4&#39;
    
    # Use sqlite3 as the database for Active Record
    # gem &#39;sqlite3&#39;
    
    # Use postgres as the database for Active Record
    gem &#39;pg&#39;
    
    # Use Puma as the app server
    gem &#39;puma&#39;, &#39;~&gt; 3.7&#39;
    # Use SCSS for stylesheets
    gem &#39;sass-rails&#39;, &#39;~&gt; 5.0&#39;
    # Use Uglifier as compressor for JavaScript assets
    gem &#39;uglifier&#39;, &#39;&gt;= 1.3.0&#39;
    # See https://github.com/rails/execjs#readme for more supported runtimes
    # gem &#39;therubyracer&#39;, platforms: :ruby
    
    # Use CoffeeScript for .coffee assets and views
    gem &#39;coffee-rails&#39;, &#39;~&gt; 4.2&#39;
    # Turbolinks makes navigating your web application faster. Read more: https://github.com/turbolinks/turbolinks
    gem &#39;turbolinks&#39;, &#39;~&gt; 5&#39;
    # Build JSON APIs with ease. Read more: https://github.com/rails/jbuilder
    gem &#39;jbuilder&#39;, &#39;~&gt; 2.5&#39;
    # Use Redis adapter to run Action Cable in production
    # gem &#39;redis&#39;, &#39;~&gt; 3.0&#39;
    # Use ActiveModel has_secure_password
    # gem &#39;bcrypt&#39;, &#39;~&gt; 3.1.7&#39;
    
    # Use Capistrano for deployment
    # gem &#39;capistrano-rails&#39;, group: :development
    
    group :development, :test do
      # Call &#39;byebug&#39; anywhere in the code to stop execution and get a debugger console
      gem &#39;byebug&#39;, platforms: [:mri, :mingw, :x64_mingw]
      # Adds support for Capybara system testing and selenium driver
      gem &#39;capybara&#39;, &#39;~&gt; 2.13&#39;
      gem &#39;selenium-webdriver&#39;
    end
    
    # gma - start
    group :development, :test do
      gem &#39;rspec-rails&#39;, &#39;~&gt; 3.5&#39;, &#39;&gt;= 3.5.2&#39;
      gem &#39;rspec-activemodel-mocks&#39;, &#39;~&gt; 1.0&#39;, &#39;&gt;= 1.0.3&#39;
      gem &#39;shoulda-matchers&#39;, &#39;~&gt; 3.1&#39;, &#39;&gt;= 3.1.1&#39;
      gem &#39;factory_bot_rails&#39;, &#39;~&gt; 4.8&#39;, &#39;&gt;= 4.8.2&#39;
      gem &#39;ffaker&#39;, &#39;~&gt; 2.2&#39;
      # gem &#39;timecop&#39;, &#39;~&gt; 0.8.1&#39;
    end
    # gma - end
    
    group :development do
      # Access an IRB console on exception pages or by using &lt;%= console %&gt; anywhere in the code.
      gem &#39;web-console&#39;, &#39;&gt;= 3.3.0&#39;
      gem &#39;listen&#39;, &#39;&gt;= 3.0.5&#39;, &#39;&lt; 3.2&#39;
      # Spring speeds up development by keeping your application running in the background. Read more: https://github.com/rails/spring
      gem &#39;spring&#39;
      gem &#39;spring-watcher-listen&#39;, &#39;~&gt; 2.0.0&#39;
    end
    
    # Windows does not include zoneinfo files, so bundle the tzinfo-data gem
    gem &#39;tzinfo-data&#39;, platforms: [:mingw, :mswin, :x64_mingw, :jruby]

  
**Schema.rb**

    ActiveRecord::Schema.define(version: 20180110153949) do
      # These are extensions that must be enabled in order to support this database
      enable_extension &quot;plpgsql&quot;
    
      create_table &quot;articles&quot;, force: :cascade do |t|
        t.string &quot;title&quot;
        t.text &quot;text&quot;
        t.datetime &quot;created_at&quot;, null: false
        t.datetime &quot;updated_at&quot;, null: false
      end
    end

**Migration file**

    class CreateComments &lt; ActiveRecord::Migration[5.1]
      def change
        create_table :comments do |t|
          t.string :commenter
          t.text :body
          t.references :article, foreign_key: true
    
          t.timestamps
        end
      end
    end


[1]: http://guides.rubyonrails.org/getting_started.html


Gem::LoadError: can&#39;t activate pg (~&gt; 0.18), already activated pg-1.0.0

I downloaded the docker container for postgres: https://hub.docker.com/r/library/postgres/, and did the following:

    $ docker run --name satgres -e POSTGRES_PASSWORD=mysecretpassword -d -p 5432:5432 postgres
    satgres | &quot;docker-entrypoint.s…&quot; | 5 seconds ago | Up 6 seconds | 0.0.0.0:5432-&gt;5432/tcp | satgres
    $ docker exec -it c8f1b22cc41e /bin/bash        
    # psql -U postgres
    psql (10.1)
    postgres=# CREATE DATABASE mytest;
    postgres=# \password postgres
    postgres=# CREATE ROLE ming WITH LOGIN PASSWORD &#39;pass1234&#39;;
    postgres=# ALTER ROLE ming CREATEDB;
    postgres=# CREATE DATABASE sjk;
    postgres=# GRANT ALL PRIVILEGES ON DATABASE youtube TO ming;
    postgres=# \connect sjk
    youtube=# ALTER ROLE ming lOGIN;  

My plan is to use this database on docker with Django, so first want to check I can connect, but I cant.

    $ psql -h localhost -p 5432 -U postgres
    $ psql: FATAL:  role &quot;postgres&quot; does not exist
    $ psql -h localhost -p 5432 -U ming
    $ psql: FATAL:  role &quot;ming&quot; does not exist

I do the same with PSequal.app, says the same thing,
Im running on Mac High Sierra. 

Why am I getting this error? The role exists, or at least it seems it to me...

Postgresql Docker role does not exist

I just upgraded to postgres 10.2 on mac os which matches 10.2 on heroku.  I&#39;m trying to download a copy of the database and restore it locally.  Before the upgrade the restore would work fine.

I run

    pg_restore --verbose --clean --no-acl --no-owner -h localhost -d database_name backup.dump

but I am getting this error:

&gt;pg_restore: [archiver] unsupported version (1.13) in file header

The database appears to be working OK.  It&#39;s a rails app and I upgraded the pg gems.  I can run `rake db:create` and `db:migrate` just fine.  


Getting &quot;[archiver] unsupported version (1.13) in file header&quot; when running pg_restore

I have successfully launched new AWS RDS PostgreSQL *v10* instance and need to install PostgreSQL v10 client on Amazon Linux EC2 instance.

I have tried to install it with `yum`, but it cant find the package for v10:

    [ec2-user@ip-X-X-X-X ~]$ sudo yum install -y postgresql10
    Loaded plugins: priorities, update-motd, upgrade-helper
    amzn-main      | 2.1 kB  00:00:00
    amzn-updates  | 2.5 kB  00:00:00
    No package postgresql110 available.
    Error: Nothing to do

Previously I managed to install PostgreSQL client v9.5 with:

    [ec2-user@ip-X-X-X-X ~]$ sudo yum install -y postgresql95

I guess I need to add Postgres yum repository, as mentioned in https://www.postgresql.org/download/linux/redhat/. But what Platform should I choose for Amazon Linux? Red Hat?

Installing PostgreSQL Client v10 on AWS Amazon Linux (EC2) AMI

From PostgreSQL document

&gt; Exclusion constraints ensure that if any two rows are compared on the
&gt; specified columns or expressions using the specified operators, at
&gt; least one of these operator comparisons will return false or null. The
&gt; syntax is:
&gt; 
&gt;     CREATE TABLE circles (
&gt;         c circle,
&gt;         EXCLUDE USING gist (c WITH &amp;&amp;)
&gt;     );

I was wondering what `EXCLUDE USING gist (c WITH &amp;&amp;)` means? In particular, `gist()`, `c WITH &amp;&amp;` and `EXCLUDE USING`. 

Can it be rewritten in terms of `check`? Thanks.

What does exclusion constraint `EXCLUDE USING gist (c WITH &amp;&amp;)` mean?

I am experiencing a problem with debugging in vscode just after the last update. There&#39;s something going on ([https://github.com/Microsoft/vscode/issues/45657][1])

I&#39;d like to check the previous version to see if my case is a problem here or in vscode but I can not find instructions on how to downgrade (I suppose it&#39;s possible)


  [1]: https://github.com/Microsoft/vscode/issues/45657

Content Type	Original Author	Original Content on Stackoverflow
Question	SokrateeS	View Question on Stackoverflow
Solution 1 - Macos	Martin Zinovsky	View Answer on Stackoverflow

How to use homebrew to downgrade postgresql from 10.1 to 9.6 on Mac OS

Macos Problem Overview

Macos Solutions

Solution 1 - Macos

Coverage.py warning: No data was collected. (no-data-collected)

ImportError: No module named 'spacy.en'

Attributions