Re: error: connection to server on socket... - Mailing list pgsql-general

From Adrian Klaver
Subject Re: error: connection to server on socket...
Date
Msg-id 863bf07c-6993-ce36-f260-6749ab327632@aklaver.com
Whole thread Raw
In response to error: connection to server on socket...  (Amn Ojee Uw <amnojeeuw@gmail.com>)
Responses Re: error: connection to server on socket...
List pgsql-general
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




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PORT 5432 ERROR
Next
From: "Wen Yi"
Date:
Subject: Re:How to build a new grammer for pg?