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

> 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