Re: BUG #13521: refused connection to host and port

On Tue, Jul 28, 2015 at 5:56 PM, <adfuser321@gmail.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13521
> Logged by:          guestUser
> Email address:      adfuser321@gmail.com
> PostgreSQL version: 9.4.4
> Operating system:   Linux
> Description:
>
> Hi,
>
> Trying to connect to Postgresql database running on remote machine using
> jdeveloper.
>
> Using 8.1 jdbc driver and exception noticed is below, tried latest and old
> driver for all the drivers it gives same error.
>
> Test failed: Connection refused. Check that the hostname and port are
> correct and that the postmaster is accepting TCP/IP connections.
> Exception: java.net.ConnectException: Connection refused
> Stack Trace:
> java.net.ConnectException: Connection refused
>         at java.net.PlainSocketImpl.socketConnect(Native Method)
>         at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
>         at
> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
>         at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
>         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
>         at java.net.Socket.connect(Socket.java:529)
>         at java.net.Socket.connect(Socket.java:478)
>         at java.net.Socket.<init>(Socket.java:375)
>         at java.net.Socket.<init>(Socket.java:189)
>         at org.postgresql.core.PGStream.<init>(PGStream.java:60)
>         at
>
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
>         at
>
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
>         at
>
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
>         at
> org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.java:24)
>         at org.postgresql.Driver.makeConnection(Driver.java:369)
>         at org.postgresql.Driver.connect(Driver.java:245)
>         at
>
> oracle.jdeveloper.db.adapter.AbstractConnectionCreator.getConnection(AbstractConnectionCreator.java:172)
>         at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source)
>         at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
>
> oracle.jdevimpl.db.extension.DatabaseConnectionHook$ConnectionType$1.invoke(DatabaseConnectionHook.java:205)
>         at $Proxy2.getConnection(Unknown Source)
>         at
>
> oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:331)
>         at
>
> oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:260)
>         at
>
> oracle.jdeveloper.db.DatabaseConnections.testConnection(DatabaseConnections.java:1077)
>         at
>
> oracle.jdevimpl.db.panels.ConnectionEditorPanel$ConnectionTester.doWork(ConnectionEditorPanel.java:749)
>         at
> oracle.ide.dialogs.ProgressRunnable.run(ProgressRunnable.java:161)
>         at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
>         at java.lang.Thread.run(Thread.java:662)
> End of Stack Trace
>

PostgreSQL database connections fails due to several reasons. Assuming that
the database is running and you are providing the correct host and port
number, what is the listen_address parameter value ? The PostgreSQL port
needs to be opened in-order to accept remote connections.

Regards,

Venkata B N
Fujitsu Australia