Skip site navigation (1) Skip section navigation (2)

Re: trying to connect to pg from within a local network

From: "Albretch Mueller" <lbrtchx(at)gmail(dot)com>
To: "Mark Lewis" <mark(dot)lewis(at)mir3(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: trying to connect to pg from within a local network
Date: 2008-01-18 17:13:50
Message-ID: 9ef66fac0801180913p3ecf6861u1262c83303178de3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
~
 Well, I went:
~
 Start > Control Panel > Windows Firewall
~
 and it is: "off (not recommended)"
~
 Something I still am not sure about is how to:
~
 "Check that the hostname and port are correct and that the postmaster
is accepting TCP/IP connnections"
~
 There is nothing I can see in pg_hba.conf or postgres.conf that
relates to TCP/IP connnections and I think it is a pg thing, because
when I run tomcat on port 8080 on this box, I can telnet to it without
any problems
~
 Tomcat is using a pg-based JDBCRealm, that means it is connecting to
it without any problems
~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ FROM client~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
C:\>ipconfig -all

Windows IP Configuration

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

Ethernet adapter Local Area Connection:

        Connection-specific DNS Suffix  . :
        Description . . . . . . . . . . . : Broadcom 440x 10/100
Integrated Controller
        Physical Address. . . . . . . . . : 00-16-45-0E-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. . . . . . . . . . : Friday, January 18, 2008 9:34:04 AM
        Lease Expires . . . . . . . . . . : Saturday, January 19, 2008
9:34:04 AM

C:\>telnet bkn-04 5432
Connecting To bkn-04...Could not open connection to the host, on port
5432: Connect failed

C:\>telnet 10.0.31.88 5432
Connecting To 10.0.31.88...Could not open connection to the host, on
port 5432: Connect failed
~
C:\>telnet bkn-04 8080
 (connects OK)
~
C:\>telnet 10.0.31.88 8080
 (connects OK)
~
C:\cmllpz\prjx\java\JDBC\PG>java PG00Test
// __ aDrvr: |org.postgresql.Driver|
// __ aDBURL: |jdbc:postgresql://bkn-04:5432/postgres|
// __ Class.forName(org.postgresql.Driver): |class org.postgresql.Driver|
// __ (Driver)KDrvr.newInstance() :|org(dot)postgresql(dot)Driver(at)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 con
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:18)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(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.<init>(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.<init>(Socket.java:365)
        at java.net.Socket.<init>(Socket.java:179)
        at org.postgresql.core.PGStream.<init>(PGStream.java:59)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
        ... 11 more
// __ database connection could not be set up!

In response to

Responses

pgsql-jdbc by date

Next:From: Mike C.Date: 2008-01-18 22:58:18
Subject: Re: trying to connect to pg from within a local network
Previous:From: Francesco StortiDate: 2008-01-18 12:04:10
Subject: Re: Problem calling stored function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group