how to configure psql to use the a different unixsocket path

Question

I changed the port of Postgres to 2345 and I have the socket in:

/tmp/.s.PGSQL.2345

If I run psql I get this error:

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory

how to pass the socket path?

Javier Galarza · Accepted Answer · 2022-02-10 11:52:19Z

2

You need to use -p option

psql -p 2345

answered Feb 10, 2022 at 11:52

Javier Galarza

811 gold badge1 silver badge6 bronze badges

that works but is using TCP or the socket?
– nbari
Feb 10, 2022 at 14:08
since you don't provide a host --host=.. psql uses its predefined socket directory by default. which is /tmp in rhel / centos etc
– Sahap Asci
Feb 10, 2022 at 14:17

Add a comment |

1 Answer 1