Re: cant connect to localhost:5432 (but unix socket ok)

2021-02-05 Thread Joao Miguel Ferreira
Hello Jain On Fri, Feb 5, 2021 at 1:16 PM Jain, Ankit wrote: > Did you try modifying the firewall settings ? > > > > Add postgres service to the firewall. If that doesn’t work, explicitly > open the port 5433 in the firewall. > > > Anyway, given these settings, "psql -p 5433 -h localhost" should

RE: cant connect to localhost:5432 (but unix socket ok)

2021-02-05 Thread Jain, Ankit
connect to localhost:5432 (but unix socket ok) CAUTION: This email originated from outside of Snap-on. Do not click on links or open attachments unless you have validated the sender, even if it is a known contact. Contact the sender by phone to validate the contents. On Thu, Feb 4, 2021 at 3:04

Re: cant connect to localhost:5432 (but unix socket ok)

2021-02-04 Thread Joao Miguel Ferreira
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 wrote: >> >>> Joao Miguel Ferreira write

Re: cant connect to localhost:5432 (but unix socket ok)

2021-02-04 Thread Joao Miguel Ferreira
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 wrote: > >> Joao Miguel Ferreira writes: >> > On Thu, Feb 4, 2021 at 2:26 PM hubert depesz lubaczewski < >> dep...@depesz.com> >> > wrote: >> >>> My

Re: cant connect to localhost:5432 (but unix socket ok)

2021-02-04 Thread Joao Miguel Ferreira
Hi Tom On Thu, Feb 4, 2021 at 2:50 PM Tom Lane wrote: > Joao Miguel Ferreira 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

Re: cant connect to localhost:5432 (but unix socket ok)

2021-02-04 Thread Tom Lane
Joao Miguel Ferreira writes: > On Thu, Feb 4, 2021 at 2:26 PM hubert depesz lubaczewski > 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 misma

Re: cant connect to localhost:5432 (but unix socket ok)

2021-02-04 Thread Joao Miguel Ferreira
On Thu, Feb 4, 2021 at 2:26 PM hubert depesz lubaczewski wrote: > On Thu, Feb 04, 2021 at 02:20:10PM +, Joao Miguel Ferreira wrote: > > My database is not listening on TCP/localhost, desptite it is listening > on the unix socket. How can I investigate this? > > I could have done something tha

Re: cant connect to localhost:5432 (but unix socket ok)

2021-02-04 Thread hubert depesz lubaczewski
On Thu, Feb 04, 2021 at 02:20:10PM +, Joao Miguel Ferreira wrote: > My database is not listening on TCP/localhost, desptite it is listening on > the unix socket. How can I investigate this? > I could have done something that is out of my understanding because I have > been loading some big pg