Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2AE472E01B6 for ; Sun, 16 Dec 2007 15:37:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 53873-08 for ; Sun, 16 Dec 2007 15:37:25 -0400 (AST) Received: from mx2.imatech.net (mx2.imatech.net [81.255.215.243]) by postgresql.org (Postfix) with ESMTP id 7C19B2E01E2 for ; Sun, 16 Dec 2007 15:37:26 -0400 (AST) Received: from mx.imatech.net ([81.255.215.253]:1835) by mx2.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Sat, 15 Dec 2007 19:58:06 +0100 X-AuthUser: olivier.boissard@cerene.fr Received: from [192.168.0.10] ([88.161.145.183]:57471) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Sun, 16 Dec 2007 20:37:18 +0100 Message-ID: <47657E70.5030103@cerene.fr> Date: Sun, 16 Dec 2007 20:37:20 +0100 From: olivier boissard User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: Peter Eisentraut CC: pgsql-admin@postgresql.org, Julio Leyva , Klay Martens Subject: Re: pg_hba.conf is driving me nuts References: <000001c83f0f$37df75b0$0100000a@klaydual> <200712161457.40344.peter_e@gmx.net> In-Reply-To: <200712161457.40344.peter_e@gmx.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/126 X-Sequence-Number: 27643 Peter Eisentraut a écrit : > Julio Leyva wrote: > >> also make sure you started postgesql with -i option, so you can connect >> from the lan >> > > He said he had set listen_addresses to '*', which is equivalent. > > to allow every one : host all all 0.0.0.0 0.0.0.0 trust and set in postgresql.conf : log_connections = on to look if connections are opened Are you running from a linux server ? Sometimes we must look at /etc/hosts.deny and /etc/hosts.allow to make sure remote hosts are not rejected. maybe you can use nmap to see if port is open . Olivier