X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 163C2D1B349 for ; Tue, 25 May 2004 14:02:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 25822-01 for ; Tue, 25 May 2004 14:02:33 -0300 (ADT) Received: from marsha.pcisys.net (marsha.pcisys.net [216.229.32.146]) by svr1.postgresql.org (Postfix) with ESMTP id 6A4AED1B1D0 for ; Tue, 25 May 2004 14:02:31 -0300 (ADT) Received: from [192.168.0.6] (moe.rbe45-127.cos.pcisys.net [216.229.45.127]) (authenticated bits=0) by marsha.pcisys.net (8.12.11/8.12.11) with ESMTP id i4PGxXN1020399 for ; Tue, 25 May 2004 10:59:33 -0600 (MDT) User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Tue, 25 May 2004 11:02:30 -0600 Subject: Re: unable to connect to pgsql server From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <5.2.1.1.0.20040524141824.02d7b060@pop6.sympatico.ca> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/50 X-Sequence-Number: 2769 on 5/24/04 2:59 PM, fbax@sympatico.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"