pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robby Russell <rrussell@commandprompt.com>
Cc: Cath Lawrence <Cath.Lawrence@anu.edu.au>
Cc: pgsql-novice@postgresql.org
Cc: pgsql-php@postgresql.org
Subject: Re: [PHP] authentication question
Date: Thu, 07 Aug 2003 10:04:13 -0400
Message-ID: <14997.1060265053@sss.pgh.pa.us> (raw)
In-Reply-To: <3F31C3A0.5010506@commandprompt.com>
References: <A19895BC-C89A-11D7-9EC1-00039390F614@anu.edu.au>
	<3F31C3A0.5010506@commandprompt.com>

Robby Russell <rrussell@commandprompt.com> 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



view thread (6+ messages)

Message-ID: <14997.1060265053@sss.pgh.pa.us>
Permalink:  ../14997.1060265053@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/14997.1060265053@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: tgl@sss.pgh.pa.us, rrussell@commandprompt.com, Cath.Lawrence@anu.edu.au, pgsql-novice@postgresql.org
  Subject: Re: [PHP] authentication question
  In-Reply-To: <14997.1060265053@sss.pgh.pa.us>
  References: <A19895BC-C89A-11D7-9EC1-00039390F614@anu.edu.au> <3F31C3A0.5010506@commandprompt.com> <14997.1060265053@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox