Hi Tom On Thu, Feb 4, 2021 at 2:50 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Joao Miguel Ferreira <joao.miguel.c.ferre...@gmail.com> writes: > > On Thu, Feb 4, 2021 at 2:26 PM hubert depesz lubaczewski < > dep...@depesz.com> > > wrote: > >>> My database is not listening on TCP/localhost, desptite it is listening > >>>> on the unix socket. How can I investigate this? > > > it's on 5433: > > Hmm, something odd there, because a port number mismatch should have > resulted in psql failing to connect via unix socket either. Maybe > you have more than one active postmaster? > yes, I see your point. makes sense. the unix socket is actually also on 5433 root@deb10tp:~# grep -nr 543 /etc/postgresql /etc/postgresql/11/main/postgresql.conf:63:port = 5433 root@deb10tp:~# find /var/run/postgresql/ | grep 543 /var/run/postgresql/.s.PGSQL.5433 /var/run/postgresql/.s.PGSQL.5433.lock root@deb10tp:~# > > Anyway, given these settings, "psql -p 5433 -h localhost" should > connect. If you still get "connection refused" then you need to > look at the kernel firewall (packet filter) settings. > yes, with "-p 5433" I can connect > > regards, tom lane thanks
