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

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

From
PG Bug reporting form
Date:
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?


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

From
Daniel Gustafsson
Date:
> 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




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

From
Shashanth Reddy
Date:
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
>



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

From
Daniel Gustafsson
Date:
> 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