On Thu, Feb 4, 2021 at 3:02 PM Joao Miguel Ferreira < joao.miguel.c.ferre...@gmail.com> wrote:
> 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? >> > "ps xauwww | grep postgres" shows only one postgres process (and a few vaccum related) > > 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 > >
