Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.2/8.9.1) with ESMTP id TAA05155 for ; Sun, 28 Mar 1999 19:09:25 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id TAA24432; Sun, 28 Mar 1999 19:08:08 -0500 (EST) To: ua01020@flashnet.it cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] pg_hba.conf In-reply-to: Your message of Sun, 28 Mar 1999 21:46:03 +0200 <99032822051500.00581@zeman> Date: Sun, 28 Mar 1999 19:08:08 -0500 Message-ID: <24430.922666088@sss.pgh.pa.us> From: Tom Lane Antonello De Santis writes: > My pg_hba.conf file looks like this: > local all trust > host all 192.168.1.0 255.255.255.0 trust That's OK as far as it goes, and I imagine that connections from your other machine will work. But for TCP connections from the same machine the postmaster is on, you *also* need host all 127.0.0.1 255.255.255.255 trust because local TCP connections usually go via the standard "loopback address" 127.0.0.1, not via any external IP address your machine may have. regards, tom lane