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.klaver@aklaver.com