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@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
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.
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.
