View Single Post

   
  #2 (permalink)  
Old 04-10-2008, 05:19 AM
Jeff Frost
 
Posts: n/a
Default Re: pg_hba.conf setup

On Thu, 29 Sep 2005, Ben Sullins wrote:

> I logged onto the linux box via ssh and edited the file by adding a line
> in pg_hba.conf for my ip. I'm thinking it other lines above my new entry
> could be affecting my access restrictions. Below are the lines in order
> as they appear in pg_hba.conf. Any assistance will be most appreciated.


Ben,

Did you reload or restart the postmaster daemon after you made your changes?

From the docs:

The pg_hba.conf file is read on start-up and when the postmaster receives a
SIGHUP signal. If you edit the file on an active system, you will need to
signal the postmaster (using pg_ctl reload or kill -HUP) to make it re-read
the file.

--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote