Si Chen <schen@graciousstyle.com> wrote:
>
> Hello.
>
> It seems that every time I make a change to pg_hba.conf, I have to
> restart the database server for the new authentication to take effect.
> Is there a way to have the server use the new pg_hba.conf authentication
> without restarting the production server.
The documentation is your friend.
Excerpt from $PGDATA/pg_hba.conf:
...
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
# "pg_ctl reload".
...
And...
$ man pg_ctl
...
reload mode simply sends the postmaster process a SIGHUP
signal, causing it to reread its configuration files
(postgresql.conf, pg_hba.conf, etc.). This allows changing
of configuration-file options that do not require a complete
restart to take effect.
...
Jim