Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux