Re: unable to connect to pgsql server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



on 5/24/04 2:59 PM, fbax@xxxxxxxxxxxx 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"



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux