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

> You should have the following in postgresql.conf: listen_addresses = '127.0.0.1,10.0.31.5'
~
 I did change it
~
> Allowing certain client IP addresses is done in pg_hba.conf.
~
 OK, I did too, this is how my /data/pg_hba.conf looks like:
~
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# IPv4 local connections:
host     all     all     127.0.0.1/32,10.0.31.62     md5
# IPv6 local connections:
#host    all         all         ::1/128               md5
~
> Try the following on the client: telnet 10.0.31.5 5432
~
C:\>telnet 10.0.31.5 5432
Connecting To 10.0.31.5...Could not open connection to the host, on
port 5432: Connect failed

C:\>ping 10.0.31.5

Pinging 10.0.31.5 with 32 bytes of data:

Reply from 10.0.31.5: bytes=32 time<1ms TTL=128
Reply from 10.0.31.5: bytes=32 time<1ms TTL=128
Reply from 10.0.31.5: bytes=32 time<1ms TTL=128
Reply from 10.0.31.5: bytes=32 time<1ms TTL=128

Ping statistics for 10.0.31.5:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

~
> Try the following on the server: netstat -a
~
 on the server:
~
C:\Documents and Settings\Administrator>netstat -a

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    BNG-04:epmap       BNG-04.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-04:microsoft-ds  BNG-04.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-04:1043        BNG-04.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-04:3389        BNG-04.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-04:4899        BNG-04.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-04:netbios-ssn  BNG-04.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-04:1059        10.0.31.5:microsoft-ds  ESTABLISHED
  TCP    BNG-04:1048        BNG-04.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-04:1093        localhost:5432         ESTABLISHED
  TCP    BNG-04:5432        BNG-04.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-04:5432        localhost:1093         ESTABLISHED
  UDP    BNG-04:microsoft-ds  *:*
  UDP    BNG-04:isakmp      *:*
  UDP    BNG-04:1025        *:*
  UDP    BNG-04:1026        *:*
  UDP    BNG-04:1058        *:*
  UDP    BNG-04:2967        *:*
  UDP    BNG-04:4500        *:*
  UDP    BNG-04:ntp         *:*
  UDP    BNG-04:netbios-ns  *:*
  UDP    BNG-04:netbios-dgm  *:*
  UDP    BNG-04:1900        *:*
  UDP    BNG-04:ntp         *:*
  UDP    BNG-04:1028        *:*
  UDP    BNG-04:1041        *:*
  UDP    BNG-04:1900        *:*
~
> Is there a firewall involved?
~
 Not from my box, which is a client to pg
~
//__ "netstat -a" on my client box
C:\>netstat -a

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    BNG-2008:microsoft-ds  BNG-2008.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-2008:netbios-ssn  BNG-2008.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-2008:1144      gwdcbke1.exchange.goodwillny.org:1025  ESTABLISHED
  TCP    BNG-2008:1152      10.0.31.5:netbios-ssn  ESTABLISHED
  TCP    BNG-2008:1262      mailserver.exchange.goodwillny.org:2128  ESTABLISHED
  TCP    BNG-2008:1341      exchange-i.exchange.goodwillny.org:9090  CLOSE_WAIT
  TCP    BNG-2008:1342      exchange-i.exchange.goodwillny.org:9090  CLOSE_WAIT
  TCP    BNG-2008:1396      exchange-i.exchange.goodwillny.org:9090  ESTABLISHED
  TCP    BNG-2008:1408      exchange-i.exchange.goodwillny.org:9090  ESTABLISHED
  TCP    BNG-2008:1044      BNG-2008.exchange.goodwillny.org:0  LISTENING
  TCP    BNG-2008:1153      localhost:1154         ESTABLISHED
  TCP    BNG-2008:1154      localhost:1153         ESTABLISHED
  TCP    BNG-2008:1155      localhost:1156         ESTABLISHED
  TCP    BNG-2008:1156      localhost:1155         ESTABLISHED
  TCP    BNG-2008:5432      BNG-2008.exchange.goodwillny.org:0  LISTENING
  UDP    BNG-2008:microsoft-ds  *:*
  UDP    BNG-2008:isakmp    *:*
  UDP    BNG-2008:1025      *:*
  UDP    BNG-2008:1026      *:*
  UDP    BNG-2008:1145      *:*
  UDP    BNG-2008:2967      *:*
  UDP    BNG-2008:4500      *:*
  UDP    BNG-2008:ntp       *:*
  UDP    BNG-2008:netbios-ns  *:*
  UDP    BNG-2008:netbios-dgm  *:*
  UDP    BNG-2008:1900      *:*
  UDP    BNG-2008:ntp       *:*
  UDP    BNG-2008:1029      *:*
  UDP    BNG-2008:1031      *:*
  UDP    BNG-2008:1042      *:*
  UDP    BNG-2008:1058      *:*
  UDP    BNG-2008:1900      *:*