Re: Prolem to acess PostgeSQL from other mechine
От | Adrian Klaver |
---|---|
Тема | Re: Prolem to acess PostgeSQL from other mechine |
Дата | |
Msg-id | 50607736.7010805@gmail.com обсуждение исходный текст |
Ответ на | Prolem to acess PostgeSQL from other mechine (Arun R T <arunrt99@ymail.com>) |
Список | pgsql-general |
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.klaver@gmail.com
В списке pgsql-general по дате отправления:
Предыдущее
От: Tom LaneДата:
Сообщение: Re: In one of negative test row-level trigger results into loop