LoginSignup
99
83

More than 5 years have passed since last update.

Postgresqlに接続できなくなった時

Last updated at Posted at 2014-09-17

開発環境でサーバーに接続できない様子で、下記のような状況。環境はタグの通り。

$ psql -l
psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

によると

rm /usr/local/var/postgres/postmaster.pid

で解決。

また別のある時は、ログを見たら /usr/local/var/postgresのpermissionが700じゃないからと言われていたのでchmodしてOK

99
83
2

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
99
83