Thread: BUG #18033: org.postgresql.util.PSQLException:
The following bug has been logged on the website: Bug reference: 18033 Logged by: Shashanth Reddy Email address: shashanthreddy7@gmail.com PostgreSQL version: 13.11 Operating system: Windows Description: 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?
> On 20 Jul 2023, at 05:11, PG Bug reporting form <noreply@postgresql.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
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 connectusing many combinations Sent from my iPhone > On Jul 20, 2023, at 4:47 AM, Daniel Gustafsson <daniel@yesql.se> wrote: > > >> >>> On 20 Jul 2023, at 05:11, PG Bug reporting form <noreply@postgresql.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 >
> On 20 Jul 2023, at 16:58, Shashanth Reddy <shashanthreddy7@gmail.com> wrote: > > Can you help me with yhe process on how to know the list of ports available for that postgres server as am not able toconnect using many combinations If it's a regular postgres installation, check the postgresql.conf configuration file. If it's a managed service then I assume it's available via some form of dashboard or configuration GUI. -- Daniel Gustafsson