Re: error: connection to server on socket...

On 8/1/23 03:22, Amn Ojee Uw wrote:
> Using the following command on my Debian 12 machine:
>
> /*sudo apt-get install postgresql postgresql-15 postgresql-client-common
> postgresql-common postgresql-contrib postgresql-doc phppgadmin
> */
>
>
> and following the instruction on this
> <https://wiki.debian.org/PostgreSql#User_access> web page I have
> installed PostgreSQL-15.
> The installation went smooth, until the following command was issued :
>
> /*sudo -u postgres psql*/
>
> ... I get an error message that reads:
>
> /*could not change directory to "/home/my_account": Permission denied*//*
> *//*psql: error: connection to server on socket
> "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory*//*
> *//*    Is the server running locally and accepting connections on that
> socket?*/
>
> What can I do to resolve this issue?

Run

pg_lsclusters

and see what port the server is running on.

>
> Thanks in advance.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com