blocks|key|2522037|text|尝试将host:+localhost添加到您的database.yml。(基于：https://stackoverflow.com/a/10793186/919641)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2522038|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/10793186/919641^0|3|F|14|17|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

Try adding <code>host: localhost</code> to your database.yml. (Based on: <a href="https://stackoverflow.com/a/10793186/919641">https://stackoverflow.com/a/10793186/919641</a>)

blocks|key|2522082|text|您的Pg+gem是根据Mac中预先安装的PostgreSQL+libpq编译的，并且您使用的是在较新版本中安装的psql，反之亦然。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2522083|这可以通过指定一个TCP/IP连接来解决，也可以通过将localhost添加到database.yml中来解决，但是最好针对您实际运行的服务器的libpq编译Pg+gem。为此，您应该能够在编译前将PATH环境变量设置为其中包含正确pg_config的文件夹。在您的情况下，这将在Postgres.app中的某个位置。|2522084|entityMap^0|2|2|1K|4|0|R|9|13|C|20|5|27|2|2R|4|38|9|3W|C|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|I|$]]

Your <code>Pg</code> gem was compiled against the PostgreSQL libpq pre-installed in Mac OS X and you're using the <code>psql</code> that you installed in a newer version, or vice versa.

This can be worked around by specifying a TCP/IP connection, by adding <code>localhost</code> to <code>database.yml</code>, but it's better to compile the <code>Pg</code> gem against the <code>libpq</code> for the server you're actually running. To do that, you should be able to set the <code>PATH</code> environment variable to the folder with the correct <code>pg_config</code> in it before compiling. In your case that'll be somewhere within <code>Postgres.app</code>.

blocks|key|46299|text|如果添加host:+localhost后仍不起作用，请删除postmaster.pid|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|46300|rm+/usr/local/var/postgres/postmaster.pid|46301|entityMap^0|4|F|T|E|0|0|15|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|I|$]]

If it does not work even after adding <code>host: localhost</code>, remove the <code>postmaster.pid</code> 

<code>rm /usr/local/var/postgres/postmaster.pid</code>

blocks|key|45303|text|您应该将host:+localhost添加到您的数据库配置中...|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|45304|entityMap^0|4|F|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

you should add <code>host: localhost</code> to your db config...

blocks|key|45310|text|我在Mac上也遇到了同样的问题。结果是我的path上的psql不能正常工作。键入以下命令，尝试启动psql：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|45311|~/projects/some_project/project-rails$+psql
++psql:+could+not+connect+to+server:+No+such+file+or+directory
Is+the+server+running+locally+and+accepting
connections+on+Unix+domain+socket+"/var/pgsql_socket/.s.PGSQL.5432"?|code-block|syntax|javascript|45312|如果您看到这一点，则表明您路径上的psql二进制文件正在尝试使用套接字进行连接，但无法进行连接(无论出于何种原因)。因为我已经下载了pgadmin，而且连接正常，所以我知道这不是服务器的问题。|offset|length|45313|通过将正确版本的pgsql添加到我的路径中，修复了该问题：|45314|export+PATH=/Applications/Postgres.app/Contents/MacOS/bin:$PATH|45315|现在psql+(和rails)很高兴了！|45316|entityMap|0|LINK|mutability|MUTABLE|url|http://www.pgadmin.org/^0|0|0|1U|7|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@$I|11|J|12|1|13]]|A|$]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

I had the same problem on a Mac. Turns out that the psql I had on my path wasn't working correctly. 
Try launching psql by typing:

<pre><code>~/projects/some_project/project-rails$ psql
 psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
</code></pre>

If you see this, it indicates the psql binary on your path is attempting to connect using socket and unable to do so (for whatever reason). Since I had already downloaded <a href="http://www.pgadmin.org" rel="noreferrer">pgadmin</a> and it was connecting fine, I knew it wasn't an issue with the server. 

Fixed it by adding the right version of pgsql to my PATH:

<pre><code>export PATH=/Applications/Postgres.app/Contents/MacOS/bin:$PATH
</code></pre>

Now psql (and rails) are happy!

blocks|key|45389|text|我也有同样的问题。您必须实际运行/启动postgres。Postgres一定是最近在我的电脑上停止运行了，所以我必须通过启动postgres服务器来确保它正在运行|type|unstyled|depth|inlineStyleRanges|entityRanges|data|45390|postgres+-D+/usr/local/var/postgres|code-block|syntax|javascript|45391|然后，下面的命令(导致我和你一样的错误)都起作用了：|45392|bundle+exec+rake+db:create+db:migrate
bundle+exec+rspec|45393|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I had this same issue. You have to actually run / start postgres. Postgres must have stopped running on my computer recently, so I had to make sure it's running by starting the postgres server

<pre><code>postgres -D /usr/local/var/postgres
</code></pre>

Then the following commands (which were causing me the same error you had) all worked:

<pre><code>bundle exec rake db:create db:migrate
bundle exec rspec
</code></pre>

blocks|key|45441|text|由于这是我的搜索结果中出现的第一篇文章，我决定发布这个更新的修复。因为上面的建议对我都不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|45442|brew+postgresql-upgrade-database|code-block|syntax|javascript|45443|它升级了postgresql数据并移动了我的旧版本。我是9.6而不是10.4|45444|找到解决方案here|offset|length|45445|entityMap|0|LINK|mutability|MUTABLE|url|https://dba.stackexchange.com/questions/75214/postgresql-not-running-on-mac^0|0|0|0|6|4|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Since This was the first post that appeared in my search result, I have decided to post the updated fix for this. Since none of the above suggestion worked for me. 

<pre><code>brew postgresql-upgrade-database
</code></pre>

It upgraded postgresql data and moved my old version. I was on 9.6 instead of 10.4

Found the solution <a href="https://dba.stackexchange.com/questions/75214/postgresql-not-running-on-mac">here</a>

blocks|key|2522182|text|find+/+-name+'postgresql.conf‘|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2522183|netstat+-an+%7C+grep+5432+#+=>+/tmp/.s.PGSQL.5432|offset|length|style|BOLD|2522184|vi+/Users/admin/Library/Application\+Support/Postgres93/var/postgresql.conf|2522185|来自：+unix_socket_directories+=‘/’|2522186|套接字到：+unix_socket_directories+=‘/var/pgsql_’|2522187|sudo+mkdir+/var/pgsql_socket|2522188|sudo+chmod+777+/var/pgsql_socket|2522189|entityMap^0|0|O|N|0|0|V|1|0|0|5|17|1|0|0|S|0|0|W|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@$D|Z|E|10|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|11|8|@$D|12|E|13|F|G]|$D|14|E|15|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|16|8|@$D|17|E|18|F|G]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|19|8|@$D|1A|E|1B|F|G]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|S|$]]

find / -name 'postgresql.conf'

netstat -an | grep 5432 # => /tmp/.s.PGSQL.5432

vi /Users/admin/Library/Application\ Support/Postgres93/var/postgresql.conf

FROM: unix_socket_directories = '/tmp'

TO: unix_socket_directories = '/var/pgsql_socket'

sudo mkdir /var/pgsql_socket

sudo chmod 777 /var/pgsql_socket

blocks|key|46262|text|对于heroku来说，这就是你所需要的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|46263|heroku+addons:create+heroku-postgresql

production:
+adapter:+postgresql
+encoding:+unicode
+host:+localhost
+#+For+details+on+connection+pooling,+see+rails+configuration+guide
+#+http://guides.rubyonrails.org/configuring.html#database-pooling
+pool:+5|code-block|syntax|javascript|46264|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For heroku this is all you need.

<pre><code>heroku addons:create heroku-postgresql

production:
 adapter: postgresql
 encoding: unicode
 host: localhost
 # For details on connection pooling, see rails configuration guide
 # http://guides.rubyonrails.org/configuring.html#database-pooling
 pool: 5
</code></pre>

blocks|key|2731982|text|我只是遇到了postgres应用程序无法在我的mac上运行的问题……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2731983|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I just had the problem that the postgres app wasn't running on my mac...

blocks|key|2522315|text|在Mac上，我有不同版本的postgresql。当我尝试brew+switch+postgresql+9.5.5时，这个问题已经解决了(我不认为版本号在这一点上很重要)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2522316|$+brew+switch+postgresql+9.5.5
Cleaning+/usr/local/Cellar/postgresql/9.6.1
Cleaning+/usr/local/Cellar/postgresql/9.6.5
Cleaning+/usr/local/Cellar/postgresql/10.2
Cleaning+/usr/local/Cellar/postgresql/10.3
Cleaning+/usr/local/Cellar/postgresql/9.5.5
Cleaning+/usr/local/Cellar/postgresql/9.5.4|code-block|syntax|javascript|2522317|顺便说一句，所有的数据都会消失。我猜有一个brew命令可以在不切换版本的情况下执行此操作，但我找不到该命令。|2522318|entityMap^0|S|S|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

On Mac, I had different versions of postgresql. This problem has been solved when I tried <code>brew switch postgresql 9.5.5</code> (I don't think version number matters at this point) 

<pre><code>$ brew switch postgresql 9.5.5
Cleaning /usr/local/Cellar/postgresql/9.6.1
Cleaning /usr/local/Cellar/postgresql/9.6.5
Cleaning /usr/local/Cellar/postgresql/10.2
Cleaning /usr/local/Cellar/postgresql/10.3
Cleaning /usr/local/Cellar/postgresql/9.5.5
Cleaning /usr/local/Cellar/postgresql/9.5.4
</code></pre>

All data will be gone away, by the way. I guess there's a brew command for doing this without switching version, which I couldn't find.

blocks|key|45655|text|我在OS+High+sierra+10.13上也遇到了同样的问题。我按照这个网站上的说明下载了10.4版本。参考：https://postgresapp.com/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|45656|然后我将其添加到bash配置文件:+export+PATH=$PATH:/Library/PostgreSQL/10.4/bin:$PATH|45657|重新启动终端。|45658|打开新的窗口终端，然后输入:+psql+-U+postgres|45659|之后你会看到这样的消息:+psql+(10.4)输入"+help“获取帮助。|45660|postgres=#|45661|entityMap|0|LINK|mutability|MUTABLE|url|https://postgresapp.com/^0|1L|O|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|12|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@]|C|$]]|$1|N|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|O|$P|$5|Q|R|S|C|$T|U]]]]

I had the same problem on OS High sierra 10.13
I followed the instructions from this website I downloaded version 10.4
ref: <a href="https://postgresapp.com/" rel="nofollow noreferrer">https://postgresapp.com/</a>

Then I added this to bash profile:
export PATH=$PATH:/Library/PostgreSQL/10.4/bin:$PATH

re start terminal. 

Open new window terminal and then type: psql -U postgres

after that you will see this message:
psql (10.4)
Type "help" for help.

postgres=#

blocks|key|2522359|text|我的问题是/etc/hosts文件发生了变化，并且没有这个关键条目：127.0.0.1++++++++++++++localhost|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2522360|entityMap^0|5|A|Y|W|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

My problem was that the <code>/etc/hosts</code> file changed and didn't have this crucial entry: <code>127.0.0.1 localhost</code>

blocks|key|45726|text|我有一个类似的问题-当我在终端运行psql命令时，我仍然得到相同的错误，所以这告诉我这不是pg+gem的问题，我应该检查postgres设置本身。所以我检查了postgres日志-在我的例子中，它们位于/usr/local/var/log/postgres.log，我看到了以下错误：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|45727|dyld:+Library+not+loaded:+/usr/local/opt/icu4c/lib/libicui18n.66.dylib
++Referenced+from:+/usr/local/opt/postgresql/bin/postgres|code-block|syntax|javascript|45728|因此，知道确切的错误帮助我解决了问题，在我的例子中，基于this+answer，我运行了|45729|brew+switch+icu4c+66.1|45730|解决了postgres重启后的问题：|45731|brew+services+restart+postgresql|45732|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/54180353/5725619^0|H|4|2T|V|0|0|S|B|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|16|8|@]|D|@$9|17|A|18|1|19]]|E|$]]|$1|M|3|N|5|H|7|1A|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1B|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|1C|8|@]|D|@]|E|$I|J]]|$1|S|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z]]]]

I had a similar issue - when I ran <code>psql</code> command in terminal I still got the same error, so that told me that it wasn't a problem with the pg gem and I should check the postgres setup itself. So I checked the postgres logs - in my case they were located at <code>/usr/local/var/log/postgres.log</code> and I saw the following error:
<pre><code>dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.66.dylib
 Referenced from: /usr/local/opt/postgresql/bin/postgres
</code></pre>
So knowing the exact error helped me resolve the issue, in my case based on <a href="https://stackoverflow.com/a/54180353/5725619">this answer</a> I ran
<pre><code>brew switch icu4c 66.1
</code></pre>
which resolved the issue after restarting postgres:
<pre><code>brew services restart postgresql
</code></pre>

I get this error every this I run my Rails app (It cannot connect to my local Postgresql)

<pre><code>/Users/leonardo/.rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.11/lib/
active_record/connection_adapters/postgresql_adapter.rb:1208:in `initialize': 
could not connect to server: No such file or directory (PG::Error)
 Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
</code></pre>

I'm using <a href="http://postgresapp.com/" rel="noreferrer">Postgres.app</a> that it's correctly running.

If I run

<pre><code>$ psql
</code></pre>

I can login properly to Postgresql console.

<pre><code>$ which psql
 /Applications/Postgres.app/Contents/MacOS/bin/psql
</code></pre>

Gemfile

<pre><code>source 'https://rubygems.org'
ruby "1.9.3"

gem 'rails', '3.2.11'
gem "pg"
</code></pre>

database.yml

<pre><code>development:
 adapter: postgresql
 encoding: unicode
 username: leonardo
 password: 
 database: zapping
 port: 5432 
</code></pre>

Postgresql (Console)

<pre><code>$ psql
leonardo=# \l
</code></pre>

<img src="https://i.stack.imgur.com/I5eC9.png" alt="enter image description here">

Postgresql adapter (pg): could not connect to server

PostgreSQL

数据库

服务器

MacOS

Unix

我每次运行我的Rails应用程序时都会收到这个错误(它不能连接到我本地的Postgresql)/Users/leonardo/.rvm/gems/ruby-1.9.3-p362/gems/activerecord-3.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:1208:in `initialize': coul

问Postgresql适配器(pg)：无法连接到服务器
EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Postgresql适配器(pg)：无法连接到服务器EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Postgresql适配器(pg)：无法连接到服务器
EN