Prolem to acess PostgeSQL from other mechine

From: Arun R T <arunrt99(at)ymail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Prolem to acess PostgeSQL from other mechine
Date: 2012-09-24 03:50:53
Message-ID: 1348458653.19527.YahooMailNeo@web190206.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
 
Thanks & Regards
------------------------------------------------------------------------------------------------

Arun R T

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2012-09-24 05:54:08 Re: foreign key from array element
Previous Message Tom Lane 2012-09-24 01:02:48 Re: Strange dump/restore effect