On Thu, Feb 4, 2021 at 3:04 PM Joao Miguel Ferreira < joao.miguel.c.ferre...@gmail.com> wrote:
> > > 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) > here is the full list: root@deb10tp:~# ps xauww | grep postgres postgres 825 0.0 0.1 213472 14980 ? S 09:59 0:01 /usr/lib/postgresql/11/bin/postgres -D /var/lib/postgresql/11/main -c config_file=/etc/postgresql/11/main/postgresql.conf postgres 847 0.0 0.0 213572 5660 ? Ss 09:59 0:00 postgres: 11/main: checkpointer postgres 848 0.0 0.0 213472 3808 ? Ss 09:59 0:00 postgres: 11/main: background writer postgres 849 0.0 0.0 213472 3688 ? Ss 09:59 0:00 postgres: 11/main: walwriter postgres 850 0.0 0.0 214012 5628 ? Ss 09:59 0:01 postgres: 11/main: autovacuum launcher postgres 852 0.0 0.4 102172 34612 ? Ss 09:59 0:10 postgres: 11/main: stats collector postgres 853 0.0 0.0 213880 4260 ? Ss 09:59 0:00 postgres: 11/main: logical replication launcher root 9652 0.0 0.0 6208 884 pts/1 S+ 15:06 0:00 grep postgres root@deb10tp:~# > > >> >> 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 >> >>
