Re: BUG #18033: org.postgresql.util.PSQLException:

Can you help me with yhe process on how to know the list of ports available for that postgres server as am not able to connect using many combinations

Sent from my iPhone

> On Jul 20, 2023, at 4:47 AM, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
>
> 
>>
>>> On 20 Jul 2023, at 05:11, PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:
>>
>> org.postgresql.util.PSQLException: Connection to localhost:5436 refused.
>> Check that the hostname and port are correct and that the postmaster is
>> accepting TCP/IP connections. AM facing this issue while trying to connect
>> to Postgres from my java code. Can you please suggest me the way to get the
>> list of ports that ara avialble for me to use?
>
> You need to connect to the port which PostgreSQL was configured to listen to,
> which in the default case is 5432. If you are unable to connect, make sure
> that the database is configured for that port, that the database is running,
> that you are connecting to the right host and that there are no firewall rules
> or similar which may block access to that port.
>
> This is unlikely to be a bug in postgres, so you should take this question to a
> more appropriate mailinglist like pgsql-general. See the mailinglist page for
> more info:
>
> https://www.postgresql.org/list/
>
> --
> Daniel Gustafsson
>