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
