psql: error: could not connect to server: No such file or directory

[moldach]

When running bash 00-postgres-init.sh I'm met wit the follwing error (from line 26):

psql: error: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

[moldach]

Need to install postgressql.
On Mac is used brew install postgresql then start the server via brew services start postgresql.

[moldach]

Despite having installed postgresql and trying to restart I'm still getting errors?

oldachm-TJLVDG:postgresql oldachm$ brew services restart postgresql
Stopping `postgresql`... (might take a while)
==> Successfully stopped `postgresql` (label: homebrew.mxcl.postgresql)
==> Successfully started `postgresql` (label: homebrew.mxcl.postgresql)
oldachm-TJLVDG:postgresql oldachm$ bash 00-postgres-init.sh 
Directory /Users/oldachm/docker/volumes/postgres exists.
37a78e8c93a4904da9812ea5afa5515c7c5230ee26675c2bd36bbcfb5c01f5d9
psql: error: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
post_setup

[moldach]

Above, It seems to be looking for /var/run/postgresql/.s.PGSQL.5432; however, when I run the following (below) from the command line I see that it's actually listening on Unix socket /tmp/.s.PGSQL.5432:

$ postgres -D /usr/local/var/postgres
2021-08-23 14:08:58.896 MDT [97709] LOG:  starting PostgreSQL 13.4 on x86_64-apple-darwin19.6.0, compiled by Apple clang version 12.0.0 (clang-1200.0.32.29), 64-bit
2021-08-23 14:08:58.898 MDT [97709] LOG:  listening on IPv6 address "::1", port 5432
2021-08-23 14:08:58.898 MDT [97709] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2021-08-23 14:08:58.900 MDT [97709] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2021-08-23 14:08:58.908 MDT [97710] LOG:  database system was shut down at 2021-08-23 13:19:18 MDT
2021-08-23 14:08:58.914 MDT [97709] LOG:  database system is ready to accept connections

Not sure if that information is helpful (or how to fix the problem)?

[rsangole]

Hey @moldach, sorry lost track of this.

Did you find a fix, or is this still an open issue?

[moldach]

Still an open issue

[lzachmann]

Same error here, no luck running 00-postgres-init.sh. Any possible leads?

[rsangole]

@moldach and @lzachmann - could you try the fix I've put here.

I've faced a similar issue and it stems from the Postgres server not being ready to accept connections just yet. This piece of code waits for the server to start accepting connections before proceeding.