Re: unable to connect to pgsql server

on 5/24/04 2:59 PM, fbax(at)sympatico(dot)ca purportedly said:

> I couldn't figure out OpenBSD options for netstat. Do these prove the same
> thing?
> # netstat -l | grep 5432
> 0xd187f7d8 stream 0 0 0xe8844498 0x0 0x0 0x0
> /tmp/.s.PGSQL.5432

You could probably do this:
# netstat -ln | grep 5432

Which should show two entries--one for TCP/IP, one for Unix Domain Socket.

> # fstat | head -n 1 ; fstat | grep 5432
> USER CMD PID FD MOUNT INUM MODE R/W DV|SZ
> _pgsql postgres 5444 3* internet stream tcp 0xd18729dc *:5432

I am not familiar with this command, but it seems to be saying that you have
a listening connection on the right port.

Some other questions:

1) If you use the IP instead of host name, do you get the same effect?
2) Have you tried not specifying a host--in which case the Unix domain
socket will be used--and does it work?

If any of the above workarounds work, I recommend using them, as I can't
imagine what the problem may be.

Best regards,

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"