X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8586A11F65B3 for ; Wed, 29 Mar 2006 23:29:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85943-02 for ; Wed, 29 Mar 2006 23:29:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5C67F11F653D for ; Wed, 29 Mar 2006 23:29:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k2U3T7ml009359; Wed, 29 Mar 2006 22:29:07 -0500 (EST) To: Tom Arthurs cc: German Raul Hoyos Parravicino , "pgsql-admin@postgresql.org" Subject: Re: Client Connection - PGAdmin In-reply-to: <442B4E4F.9020609@jobflash.com> References: <912a25750603291823q6b2f64c9l17c111a75ea81556@mail.gmail.com> <442B4E4F.9020609@jobflash.com> Comments: In-reply-to Tom Arthurs message dated "Wed, 29 Mar 2006 19:19:43 -0800" Date: Wed, 29 Mar 2006 22:29:07 -0500 Message-ID: <9358.1143689347@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.114 required=5 tests=[AWL=0.114] X-Spam-Score: 0.114 X-Spam-Level: X-Archive-Number: 200603/356 X-Sequence-Number: 21113 Tom Arthurs writes: > Did you change this in your postgresql.conf: > listen_addresses = '*' > it defaults only to localhost Also, you might need to change kernel packet filtering rules to allow traffic to port 5432 to get through the firewall. "Connection refused" indicates either that the postmaster is not listening on port 5432 (see above) or the kernel is bouncing the packet before it gets there. regards, tom lane