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

[Amn Ojee Uw <amnojeeuw@xxxxxxxxx>]

Thank you Adrian. It Worked!!!


On 8/1/23 2:55 p.m., Adrian Klaver wrote:
> On 8/1/23 11:42, Amn Ojee Uw wrote:
> > Ah! Adrean, here is something interesting.
> >
> > /*pg_lsclusters*/ displays the following information
> >
> > /*Ver Cluster Port Status                Owner    Data 
> > directory              Log file*//*
> > *//*12  main    5432 down,binaries_missing postgres 
> > /var/lib/postgresql/12/main 
> > /var/log/postgresql/postgresql-12-main.log*//*
> > *//*15  main    5433 online                postgres 
> > /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log*/
> >
> > What is version 12 is doing there, I thought that I had completely 
> > removed it and replaced it with version 15!!
>
> You didn't, read:
>
> https://www.postgresql.org/message-id/20230731125247.puiaz7fjkfvljdwy%40alvherre.pgsql 
>
>
> and
>
> https://www.postgresql.org/message-id/33f0fc61-2d0f-60bd-e0ed-4cada3c30301@xxxxxxxxxxx 
>
>
> The clue is "binaries_missing".
>
> You remove(ed) all the files except the conf files.
>
>
> > Should I remove that log file?
>
> Run:
>
> sudo apt purge postgresql-12
>
> That will take care of removing all the conf files.
>
>
> To connect you need to specify the correct port, 5433 or do:
>
> sudo vi /etc/postgresql/15/main/postgresql.conf
>
> and change
>
> port = 5433
>
> to
>
> port = 5432
>
> Then restart the server.
>
> You then need to spend some time at the links in this message:
>
> https://www.postgresql.org/message-id/c1ad730a-a84a-ae97-2f23-6891cb06ef26%40aklaver.com 
>
>
> > Regarding /pf@xxxxxxxxxxx/ assertion, I am working with a _/Debian 
> > 12/_ machine and /*ls -l /tmp/.s.PGSQL.5432*/
> > displays the following error message : /*ls: cannot access 
> > '/tmp/.s.PGSQL.5432': No such file or directory*/
> >
> > As for Tomas Pospisek questions :
> > * as which user are you doing that (you can see that via `id`)?
> >
> >     Due to matters of security let us assume that the output is :
> >     /*id*//*
> >     *//*uid=1000(my_account) gid=1000(my_account)
> > groups=1000(my_account),24(cdrom),25(floppy),27(sudo),29(audio),30(dip),44(video),46(plugdev),100(users),*/
> > /*106(netdev),111(bluetooth),113(lpadmin),116(scanner),122(postgres),1001(tomcat)*/
> >
> > * in which directory are you executing it  (you can see that via `pwd`)?
> >
> >     /*/home/*//*my_account*/
> >
> > * what is the home directory of the postgres user (you can see that 
> > via `grep postgres /etc/passwd`) /*
> > */
> >
> >     /*~$ grep postgres /etc/passwd*//*
> >     *//*postgres:x:113:122:PostgreSQL
> >     administrator,,,:/var/lib/postgresql:/bin/bash*/
> >
> > * what does `ls -ld /var/run/postgresql/; ls -l 
> > /var/run/postgresql/.s.PGSQL.5432` show?
> >
> >     /*ls -ld /var/run/postgresql/*//*
> >     *//*drwxrwsr-x 2 postgres postgres 100 Jul 31 20:45
> >     /var/run/postgresql/*/
> >
> >     /*ls -l /var/run/postgresql/.s.PGSQL.5432*//*
> >     *//*ls: cannot access '/var/run/postgresql/.s.PGSQL.5432': No such
> >     file or directory*/
> >
> >
> > - what does `journalctl -xeu postgresql` say?
> >
> >     /*sudo journalctl -xeu postgresql*//*
> >     *//*[sudo] password for *//*/**//*my_account*/: *//*
> >     *//*░░ Support: https://www.debian.org/support*//*
> >     *//*░░ *//*
> >     *//*░░ A start job for unit postgresql.service has begun 
> > execution.*//*
> >     *//*░░ *//*
> >     *//*░░ The job identifier is 3496.*//*
> >     *//*Jul 31 20:45:13 *//*tree.com systemd[1]: Finished
> >     postgresql.service - PostgreSQL R>*//*
> >     *//*░░ Subject: A start job for unit postgresql.service has finished
> >     successfully*//*
> >     *//*░░ Defined-By: systemd*//*
> >     *//*░░ Support: https://www.debian.org/support*//*
> >     *//*░░ *//*
> >     *//*░░ A start job for unit postgresql.service has finished
> >     successfully.*//*
> >     *//*░░ *//*
> >     *//*░░ The job identifier is 3496.*//*
> >     *//*lines 4-16/16 (END)*/
> >
> > - what does `tail -n 20 
> > /var/log/postgresql/postgresql-*-qgisclouddb.log` show?
> >
> >     /*sudo tail -n 20 
> > /var/log/postgresql/postgresql-*-qgisclouddb.log*//*
> >     *//*tail: cannot open
> >     '/var/log/postgresql/postgresql-*-qgisclouddb.log' for reading: No
> >     such file or directory*/
> >
> >
> > I hope I was able to answer all the interesting questions posted as 
> > reply to my original post.
> >
> > /Thanks folks, I really appreciate the time you have dedicated to my 
> > question./
> >
> >
> > On 8/1/23 10:35 a.m., Adrian Klaver wrote:
> > > 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.