X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B12AD9528 for ; Wed, 21 Sep 2005 06:26:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33440-04 for ; Wed, 21 Sep 2005 09:26:09 +0000 (GMT) Received: from titan.ecommit.de (titan.ecommit.de [195.145.58.245]) by svr1.postgresql.org (Postfix) with ESMTP id 33098D9526 for ; Wed, 21 Sep 2005 06:26:09 -0300 (ADT) Received: from titan.ecommit.de (localhost [127.0.0.1]) by titan.ecommit.de (8.12.6/8.12.6/SuSE Linux 0.6) with ESMTP id j8L9QBFl001810; Wed, 21 Sep 2005 11:26:11 +0200 Received: from titan.ecommit.de (root@localhost) by titan.ecommit.de (8.12.6/8.12.6/Submit) with ESMTP id j8L9QAM1001809; Wed, 21 Sep 2005 11:26:11 +0200 Received: from fandelm.tc.de (fandelm.tc.de 192.168.252.51) by titan.ecommit.de (Scalix SMTP Relay 9.0.0.26) via ESMTP; Wed, 21 Sep 2005 11:26:08 +0200 (CEST) Date: Wed, 21 Sep 2005 11:22:04 +0200 From: "Martin Fandel" To: Nirav Parikh Cc: pgsql-admin@postgresql.org Message-ID: <1127294524.20648.27.camel@fandelm.tc.de> In-Reply-To: <221385EC3F18A44DB0925467A1D2395F34A33F@exsrv3.workskillsprofes> References: <221385EC3F18A44DB0925467A1D2395F34A33F@exsrv3.workskillsprofes> Subject: Re: pgsql connection x-scalix-Hops: 1 X-Mailer: Evolution 2.0.1 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=-t14SPmKmdDjy1LJuMGIM" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.033 required=5 tests=[AWL=0.032, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/217 X-Sequence-Number: 18954 --=-t14SPmKmdDjy1LJuMGIM Content-Type: text/plain Content-Disposition: inline Hi, what does "iptables -L" and "/var/log/postgresql" say? Is there a packetfilter? The socket sems to be ok. Can you telnet to the the socket? Regards, Martin Am Mittwoch, den 21.09.2005, 16:08 +0800 schrieb Nirav Parikh: > Hi Martin, > > Thanks for prompt reply. As I said before I can connect through > different server but can't connect locally. > > This is the result of netstat -anp | grep postmaster > > tcp 0 0 0.0.0.0:5432 0.0.0.0:* > LISTEN 2094/postmaster > tcp 0 0 :::5432 :::* > LISTEN 2094/postmaster > udp 0 0 127.0.0.1:32769 127.0.0.1:32769 > ESTABLISHED 2094/postmaster > unix 2 [ ACC ] STREAM LISTENING 5996 > 2094/postmaster /tmp/.s.PGSQL.5432 > > I changed settings in posgresql.conf but still no luck. > > listen_addresses = 'localhost' > port = 5432 > > Is there anything else I can try? > > > > regards, > > Nirav > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: > 20/09/2005 > > --=-t14SPmKmdDjy1LJuMGIM Content-Type: text/html; charset="utf-8" Content-Disposition: inline Hi,

what does "iptables -L" and "/var/log/postgresql" say? Is there a packetfilter? The socket sems to be ok.
Can you telnet to the the socket?

Regards,

Martin

Am Mittwoch, den 21.09.2005, 16:08 +0800 schrieb Nirav Parikh:
Hi Martin,

Thanks for prompt reply. As I said before I can connect through different server but can't connect locally.
 
This is the result of  netstat -anp | grep postmaster
 
tcp        0      0 0.0.0.0:5432                0.0.0.0:*                   LISTEN      2094/postmaster
tcp        0      0 :::5432                     :::*                        LISTEN      2094/postmaster
udp        0      0 127.0.0.1:32769             127.0.0.1:32769             ESTABLISHED 2094/postmaster
unix  2      [ ACC ]     STREAM     LISTENING     5996   2094/postmaster     /tmp/.s.PGSQL.5432

I changed settings in posgresql.conf but still no luck.
 
listen_addresses = 'localhost'
port = 5432
 
Is there anything else I can try?


 
regards,
 
Nirav



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 20/09/2005


--=-t14SPmKmdDjy1LJuMGIM--