pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18033: org.postgresql.util.PSQLException:
4+ messages / 3 participants
[nested] [flat]
* BUG #18033: org.postgresql.util.PSQLException:
@ 2023-07-20 03:11 PG Bug reporting form <noreply@postgresql.org>
2023-07-20 08:47 ` Re: BUG #18033: org.postgresql.util.PSQLException: Daniel Gustafsson <daniel@yesql.se>
0 siblings, 1 reply; 4+ messages in thread
From: PG Bug reporting form @ 2023-07-20 03:11 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: shashanthreddy7@gmail.com
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?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #18033: org.postgresql.util.PSQLException:
2023-07-20 03:11 BUG #18033: org.postgresql.util.PSQLException: PG Bug reporting form <noreply@postgresql.org>
@ 2023-07-20 08:47 ` Daniel Gustafsson <daniel@yesql.se>
2023-07-20 14:58 ` Re: BUG #18033: org.postgresql.util.PSQLException: Shashanth Reddy <shashanthreddy7@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Daniel Gustafsson @ 2023-07-20 08:47 UTC (permalink / raw)
To: shashanthreddy7@gmail.com; pgsql-bugs@lists.postgresql.org
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #18033: org.postgresql.util.PSQLException:
2023-07-20 03:11 BUG #18033: org.postgresql.util.PSQLException: PG Bug reporting form <noreply@postgresql.org>
2023-07-20 08:47 ` Re: BUG #18033: org.postgresql.util.PSQLException: Daniel Gustafsson <daniel@yesql.se>
@ 2023-07-20 14:58 ` Shashanth Reddy <shashanthreddy7@gmail.com>
2023-07-20 15:06 ` Re: BUG #18033: org.postgresql.util.PSQLException: Daniel Gustafsson <daniel@yesql.se>
0 siblings, 1 reply; 4+ messages in thread
From: Shashanth Reddy @ 2023-07-20 14:58 UTC (permalink / raw)
To: Daniel Gustafsson <daniel@yesql.se>; +Cc: pgsql-bugs@lists.postgresql.org
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@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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #18033: org.postgresql.util.PSQLException:
2023-07-20 03:11 BUG #18033: org.postgresql.util.PSQLException: PG Bug reporting form <noreply@postgresql.org>
2023-07-20 08:47 ` Re: BUG #18033: org.postgresql.util.PSQLException: Daniel Gustafsson <daniel@yesql.se>
2023-07-20 14:58 ` Re: BUG #18033: org.postgresql.util.PSQLException: Shashanth Reddy <shashanthreddy7@gmail.com>
@ 2023-07-20 15:06 ` Daniel Gustafsson <daniel@yesql.se>
0 siblings, 0 replies; 4+ messages in thread
From: Daniel Gustafsson @ 2023-07-20 15:06 UTC (permalink / raw)
To: Shashanth Reddy <shashanthreddy7@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
> 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 to connect 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-07-20 15:06 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-20 03:11 BUG #18033: org.postgresql.util.PSQLException: PG Bug reporting form <noreply@postgresql.org>
2023-07-20 08:47 ` Daniel Gustafsson <daniel@yesql.se>
2023-07-20 14:58 ` Shashanth Reddy <shashanthreddy7@gmail.com>
2023-07-20 15:06 ` Daniel Gustafsson <daniel@yesql.se>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox