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