CODEWITHSUNDEEP
postgresql
John Winston
John Winston

Reputation: 1471

Connect to postgres with custom database cluster location with psql

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?

Upvotes: 0

Views: 406

Answers (1)

Paul Beerkens
Paul Beerkens

Reputation: 148

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

psql -h $PWD -p 5432 postgres

Upvotes: 1

Related Questions