Re: Re-initialize pg_hba.conf file? - Mailing list pgsql-admin

From Miroslav Šulc
Subject Re: Re-initialize pg_hba.conf file?
Date
Msg-id 42384563.8050905@startnet.cz
Whole thread Raw
In response to Re-initialize pg_hba.conf file?  (David Wagoner <dbwagoner@gmail.com>)
Responses Re: Re-initialize pg_hba.conf file?  (David Wagoner <dbwagoner@gmail.com>)
List pgsql-admin
David Wagoner wrote:

>Is there a way to have Postgres re-read the pg_hba.conf file while the
>database is up and running (i.e., no restarting)?  Perhaps using
>SIGHUP?
>
>
I think you're right with the SIGHUP. In my init script from Gentoo
there is option to reload (which I think is the same):
su - $PGUSER -c "/usr/bin/pg_ctl reload -D '$PGDATA' -s"

>I added a user entry to the pg_hba.conf file and cannot bounce the database.
>
>thanks,
>
>david
>
Miroslav

Attachment

pgsql-admin by date:

Previous
From: "Jason Minion"
Date:
Subject: Re: Re-initialize pg_hba.conf file?
Next
From: David Wagoner
Date:
Subject: Re: Re-initialize pg_hba.conf file?