X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B4A8AD1C4DB; Thu, 7 Aug 2003 14:05:07 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 75282-10; Thu, 7 Aug 2003 11:03:47 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B92EAD1C4BC; Thu, 7 Aug 2003 11:04:56 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h77E4DSa014998; Thu, 7 Aug 2003 10:04:13 -0400 (EDT) To: Robby Russell Cc: Cath Lawrence , pgsql-novice@postgresql.org, pgsql-php@postgresql.org Subject: Re: [PHP] authentication question In-reply-to: <3F31C3A0.5010506@commandprompt.com> References: <3F31C3A0.5010506@commandprompt.com> Comments: In-reply-to Robby Russell message dated "Wed, 06 Aug 2003 23:12:32 -0400" Date: Thu, 07 Aug 2003 10:04:13 -0400 Message-ID: <14997.1060265053@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/56 X-Sequence-Number: 7862 Robby Russell writes: > I'm not sure if this will help you or not, but try adding this to the > bottom (seen this as a common practice) > # reject all connections from all hosts not granted above > host all 0.0.0.0 0.0.0.0 reject This is unnecessary --- if the postmaster falls off the end of the file without a match, it defaults to "reject". Nothing wrong with having such a line for documentation purposes, but it shouldn't change the behavior one bit. My guess about Cath's original problem is that the lines she showed us only controlled attempted connections to the "temp" database ... not to any other database. If she had more lines later in the file, those would be consulted for any connection to a database not named "temp". Another common mistake (been burnt this way more than once) is to forget to SIGHUP the postmaster (eg, pg_ctl reload) after editing the config file. You can get *really* confused if you are trying different things and sometimes you remember to SIGHUP and sometimes you don't. regards, tom lane