Re: Prolem to acess PostgeSQL from other mechine

On 09/23/2012 08:50 PM, Arun R T wrote:
>
> Hi
>
> I have some problem to connect PostgeSQL server from client mechine,
> error and code is given below. I am using Windows 7 OS
>
> Code
>
> public static void main(String[] args) {
>
> try {
> System.out.println("Connecting..................");
> Class.forName("org.postgresql.Driver").newInstance();
> connection =
> DriverManager.getConnection("jdbc:postgresql://10.10.10.101:6060/mydb",
> "postgres", "welcome");
> } catch (Exception e) {
> e.printStackTrace();
> }
> }
>
> Error
>
> org.postgresql.util.PSQLException: Connection refused. Check that the
> hostname and port are correct and that the postmaster is accepting
> TCP/IP connections.
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
> at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:123)
> at
> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:28)
> at
> org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:20)
> at
> org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
> at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:22)
> at org.postgresql.Driver.makeConnection(Driver.java:391)
> at org.postgresql.Driver.connect(Driver.java:265)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at com.web.view.TestLogic.main(TestLogic.java:15)
> Caused by: java.net.ConnectException: Connection timed out: connect
> at java.net.DualStackPlainSocketImpl.connect0(Native Method)
> at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
> at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
> at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
> at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
> at java.net.PlainSocketImpl.connect(Unknown Source)
> at java.net.SocksSocketImpl.connect(Unknown Source)
> at java.net.Socket.connect(Unknown Source)
> at java.net.Socket.connect(Unknown Source)
> at java.net.Socket.<init>(Unknown Source)
> at java.net.Socket.<init>(Unknown Source)
> at org.postgresql.core.PGStream.<init>(PGStream.java:60)
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:74)
> ... 11 more
>
> I am also sets
>
> postgresql.conf
>
> listen_addresses = '*' # what IP address(es) to listen on;
> # comma-separated list of addresses;
>
>
> pg_hba.conf
>
> # TYPE DATABASE USER ADDRESS METHOD
>
> # IPv4 local connections:
> host all all 10.10.10.100/32 trust
> # IPv6 local connections:
> host all all 0.0.0.0/0 trust
> # Allow replication connections from localhost, by a user with the
> # replication privilege.
> # host replication postgres 127.0.0.1/32 md5
> # host replication postgres ::1/128 md5
>
>
> Please give me a solution

Did you restart the server after making the above changes?
A restart is needed for the listen_address change to be seen.

Its unclear where the server is running. Is it running on Windows or is
the client running on Windows? In either case is there a firewall
between the two that could be preventing a connection?

> Thanks & Regards
> ------------------------------------------------------------------------------------------------
>
> *Arun R T*

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com