Connect to postgres with custom database cluster location with psql

Question

Instead of using /usr/local/pgsql/data, I create my database cluster with the following code

initdb -D /tmp/psql
pg_ctl -D /tmp/psql -l logfile -o "--unix_socket_directories='$PWD'" start

But when I run psql, I get the following error.

psql: error: 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"?

I have read the doc and I cannot find related options for changing the location for database cluster. What have I missed?

Add to your question the connection string you are using with psql. In meantime I'm guessing the issue is you are not using a -h in the connection string and psql is falling back to the compiled in default for the socket directory. To override this in the connection string see libpq under host. — Adrian Klaver
– Adrian Klaver, Commented Jul 6, 2021 at 14:53

Paul Beerkens · Accepted Answer · 2021-07-20 16:27:59Z

1

I ran into the same issue and specifying the socket directory with the -h option fixes the issue.

psql -h $PWD -p 5432 postgres

answered Jul 20, 2021 at 16:27

Paul Beerkens

1481 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to postgres with custom database cluster location with psql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related