pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feederror: connection to server on socket...
10+ messages / 6 participants
[nested] [flat]
* error: connection to server on socket...
@ 2023-08-01 10:22 Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 10:25 ` Re: error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 10:38 ` Re: error: connection to server on socket... Tomas Pospisek <tpo2@sourcepole.ch>
2023-08-01 11:28 ` Re: error: connection to server on socket... pf@pfortin.com
2023-08-01 14:35 ` Re: error: connection to server on socket... Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 4 replies; 10+ messages in thread
From: Amn Ojee Uw @ 2023-08-01 10:22 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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?
Thanks in advance.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
@ 2023-08-01 10:25 ` Amn Ojee Uw <amnojeeuw@gmail.com>
3 siblings, 0 replies; 10+ messages in thread
From: Amn Ojee Uw @ 2023-08-01 10:25 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
_*Addendum*_
I tried this, but to no avail : /*sudo systemctl start postgresql*/
On 8/1/23 6:22 a.m., 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?
>
> Thanks in advance.
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
@ 2023-08-01 10:38 ` Tomas Pospisek <tpo2@sourcepole.ch>
3 siblings, 0 replies; 10+ messages in thread
From: Tomas Pospisek @ 2023-08-01 10:38 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On 01.08.23 12: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?
When executing the `sudo` command above:
* as which user are you doing that (you can see that via `id`)?
* in which directory are you executing it (you can see that via `pwd`)?
* what is the home directory of the postgres user (you can see that via
`grep postgres /etc/passwd`)
* what does `ls -ld /var/run/postgresql/; ls -l
/var/run/postgresql/.s.PGSQL.5432` show?
You also wrote:
> I tried this, but to no avail : `sudo systemctl start postgresql`
- what does `journalctl -xeu postgresql` say?
- what does `tail -n 20
/var/log/postgresql/postgresql-*-qgisclouddb.log` show?
*t
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
@ 2023-08-01 11:28 ` pf@pfortin.com
2023-08-01 11:57 ` Re: error: connection to server on socket... Matthias Apitz <guru@unixarea.de>
2023-08-01 13:10 ` Re: error: connection to server on socket... Tom Lane <tgl@sss.pgh.pa.us>
3 siblings, 2 replies; 10+ messages in thread
From: pf@pfortin.com @ 2023-08-01 11:28 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On Tue, 1 Aug 2023 06:22:46 -0400 Amn Ojee Uw wrote:
>"/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory*//*
Like mine, your distro probably uses /tmp/.s.PGSQL.5432
$ ll /tmp/.s.PGSQL.5432
srwxrwxrwx 1 postgres postgres 0 Aug 1 06:33 /tmp/.s.PGSQL.5432=
https://askubuntu.com/questions/50621/can-not-connect-to-postgresql-listening-on-port-5432
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 11:28 ` Re: error: connection to server on socket... pf@pfortin.com
@ 2023-08-01 11:57 ` Matthias Apitz <guru@unixarea.de>
1 sibling, 0 replies; 10+ messages in thread
From: Matthias Apitz @ 2023-08-01 11:57 UTC (permalink / raw)
To: pf@pfortin.com; +Cc: pgsql-general@lists.postgresql.org
El día martes, agosto 01, 2023 a las 07:28:49 -0400, pf@pfortin.com escribió:
> On Tue, 1 Aug 2023 06:22:46 -0400 Amn Ojee Uw wrote:
>
> >"/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory*//*
>
> Like mine, your distro probably uses /tmp/.s.PGSQL.5432
> $ ll /tmp/.s.PGSQL.5432
> srwxrwxrwx 1 postgres postgres 0 Aug 1 06:33 /tmp/.s.PGSQL.5432=
>
This here is on SuSE Linux:
# ls -l /tmp/.*5432
srwxrwxrwx 1 postgres postgres 0 Aug 1 13:39 /tmp/.s.PGSQL.5432
# netstat -an | grep 5432 | grep LIST
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN
tcp6 0 0 :::5432 :::* LISTEN
unix 2 [ ACC ] STREAM LISTENING 22000 /tmp/.s.PGSQL.5432
We normaly use the TCP/IP port 5432 to connect to the server.
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 11:28 ` Re: error: connection to server on socket... pf@pfortin.com
@ 2023-08-01 13:10 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 10+ messages in thread
From: Tom Lane @ 2023-08-01 13:10 UTC (permalink / raw)
To: pf@pfortin.com; +Cc: pgsql-general@lists.postgresql.org, Amn Ojee Uw <amnojeeuw@gmail.com>
pf@pfortin.com writes:
> On Tue, 1 Aug 2023 06:22:46 -0400 Amn Ojee Uw wrote:
>> "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory*//*
> Like mine, your distro probably uses /tmp/.s.PGSQL.5432
> $ ll /tmp/.s.PGSQL.5432
> srwxrwxrwx 1 postgres postgres 0 Aug 1 06:33 /tmp/.s.PGSQL.5432=
Yeah. Look to see if there's a socket file there, and if so try
sudo -u postgres psql -h /tmp
In the longer term, this indicates that you have a psql that did
not come from the same packager as your server, because the server
thinks the default socket location is /tmp, but psql (or really
the libpq.so it's using) thinks the default location is
/var/run/postgresql. That's a build-time choice that some
packagers make because $standards. So the long-term fix is to
not have a hodge-podge of different Postgres installations on
the same machine.
BTW, you can ignore the "could not change directory" warning.
That's expected when starting "sudo -u postgres psql" in a
directory that the postgres user can't read.
regards, tom lane
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
@ 2023-08-01 14:35 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-01 18:42 ` Re: error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
3 siblings, 1 reply; 10+ messages in thread
From: Adrian Klaver @ 2023-08-01 14:35 UTC (permalink / raw)
To: Amn Ojee Uw <amnojeeuw@gmail.com>; pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 14:35 ` Re: error: connection to server on socket... Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-08-01 18:42 ` Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 18:55 ` Re: error: connection to server on socket... Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 10+ messages in thread
From: Amn Ojee Uw @ 2023-08-01 18:42 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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!!
Should I remove that log file?
Regarding /pf@pfortin.com/ 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.
>>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 14:35 ` Re: error: connection to server on socket... Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-01 18:42 ` Re: error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
@ 2023-08-01 18:55 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-01 22:40 ` Re: error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Adrian Klaver @ 2023-08-01 18:55 UTC (permalink / raw)
To: Amn Ojee Uw <amnojeeuw@gmail.com>; pgsql-general@lists.postgresql.org
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@aklaver.com
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@pfortin.com/ 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@aklaver.com
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: error: connection to server on socket...
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 14:35 ` Re: error: connection to server on socket... Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-01 18:42 ` Re: error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 18:55 ` Re: error: connection to server on socket... Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-08-01 22:40 ` Amn Ojee Uw <amnojeeuw@gmail.com>
0 siblings, 0 replies; 10+ messages in thread
From: Amn Ojee Uw @ 2023-08-01 22:40 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general@lists.postgresql.org
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@aklaver.com
>
>
> 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@pfortin.com/ 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.
>>>>
>>>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2023-08-01 22:40 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-01 10:22 error: connection to server on socket... Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 10:25 ` Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 10:38 ` Tomas Pospisek <tpo2@sourcepole.ch>
2023-08-01 11:28 ` pf@pfortin.com
2023-08-01 11:57 ` Matthias Apitz <guru@unixarea.de>
2023-08-01 13:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-08-01 14:35 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-01 18:42 ` Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-01 18:55 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-01 22:40 ` Amn Ojee Uw <amnojeeuw@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox