| From: | Joao Miguel Ferreira <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
|---|---|
| To: | "Jain, Ankit" <Ankit(dot)Jain(at)snapon(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "depesz(at)depesz(dot)com" <depesz(at)depesz(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: cant connect to localhost:5432 (but unix socket ok) |
| Date: | 2021-02-05 13:55:58 |
| Message-ID: | CALyyT7T=X+58tVCk2s82ZJV9LQB2zTZ4dEviQYzH=K0A+1QKjg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello Jain
On Fri, Feb 5, 2021 at 1:16 PM Jain, Ankit <Ankit(dot)Jain(at)snapon(dot)com> 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
> 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
>
>
>
> It was not necessary to change firewall settings because I was able to
connect to the database with the "-p 5433" option
and all is fine now
thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thorsten Schöning | 2021-02-05 16:02:23 | Less efficient query plan after merging tables |
| Previous Message | Laurenz Albe | 2021-02-05 13:26:12 | Re: updating(column) Porting from Oracle Trigger to PostgreSQL trigger |