[JDBC] trying to connect to pg from within a local network

From: Albretch Mueller <lbrtchx(at)gmail.com>
Date: Wed Jan 16 2008 - 09:22:19 EST

// __ trying to connect from 10.0.31.62
~

 Hi,
~

 I need to connect to a pg Windows installation that I have within the same network
~

 as listen_address I have listed: localhost, 127.0.0.1, 10.0.31.5, 10.0.31.62
~

 10.0.31.5 is this "localhost" in the 10.0.31.* local network and 10.0.31.62 is me
~

 I have check all I can think of and it still does not work. Why can't I connect to pg from within the local network?
~

 Thanks
 lbrtchx
~

C:\cmllpz\prjx\java\JDBC\PG>java PG00Test

// __ aDrvr: |org.postgresql.Driver|
// __ aDBURL: |jdbc:postgresql://10.0.31.5:5432/postgres|
// __ Class.forName(org.postgresql.Driver): |class org.postgresql.Driver|
// __ (Driver)KDrvr.newInstance() :|org.postgresql.Driver@1893efe|
// __ DriverManager.registerDriver(OKDrvr);

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:122)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.java:18)
        at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:382)
        at org.postgresql.Driver.connect(Driver.java:260)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at PG00.(PG00Test.java:26)
        at PG00Test.main(PG00Test.java:213)
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:518)
        at java.net.Socket.connect(Socket.java:468)
        at java.net.Socket.(Socket.java:365)
Do you need help?
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:
Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related postgresql.org Links
pgsql-admin
pgsql-advocacy
pgsql-announce
pgsql-bugs
pgsql-cygwin
pgsql-docs
pgsql-general
pgsql-interfaces
pgsql-jdbc
pgsql-jobs
pgsql-novice
pgsql-odbc
pgsql-performance
pgsql-php
pgsql-ports
pgsql-sql
Request more information about Pantek
        at java.net.Socket.(Socket.java:179)
        at org.postgresql.core.PGStream.(PGStream.java:59)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
        ... 11 more

// __ database connection could not be set up!

C:\cmllpz\prjx\java\JDBC\PG>ipconfig -all

Windows IP Configuration

        Host Name . . . . . . . . . . . . : BGN-2008
        Primary Dns Suffix  . . . . . . . : exchange.thetrade.org
        Node Type . . . . . . . . . . . . : Unknown
        IP Routing Enabled. . . . . . . . : No
        WINS Proxy Enabled. . . . . . . . : No
        DNS Suffix Search List. . . . . . : exchange.thetrade.org
                                            thetrade.org

Ethernet adapter Local Area Connection:

        Connection-specific DNS Suffix  . :
        Description . . . . . . . . . . . : Broadcom 440x 10/100
Integrated Controller
        Physical Address. . . . . . . . . : 00-16-E6-45E-F5-27
        Dhcp Enabled. . . . . . . . . . . : Yes
        Autoconfiguration Enabled . . . . : Yes
        IP Address. . . . . . . . . . . . : 10.0.31.62
        Subnet Mask . . . . . . . . . . . : 255.255.255.0
        Default Gateway . . . . . . . . . : 10.0.31.1
        DHCP Server . . . . . . . . . . . : 10.0.31.1
        DNS Servers . . . . . . . . . . . : 10.0.1.23
                                            10.0.1.74
        Lease Obtained. . . . . . . . . . : Tuesday, January 15, 2008 9:18:55 PM
        Lease Expires . . . . . . . . . . : Wednesday, January 16,

2008 9:18:55 PM

C:\cmllpz\prjx\java\JDBC\PG>

~

C:\cmllpz\prjx\java\JDBC\PG>tracert 10.0.31.5

Tracing route to 10.0.31.5 over a maximum of 30 hops

  1 <1 ms <1 ms <1 ms 10.0.31.5

Trace complete.
~

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Received on Wed Jan 16 09:47:39 2008