JBY Technologies

Postgres Reload pg_hba.conf

I needed to add permission for a new subnet to access Postgres 9.2. I couldn't restart Postgres because it is the standby in a binary streaming replication. I added my network and authentication rule to pg_hba.conf and did the following...

su - postgres

pg_ctl reload -D /usr/local/pgsql/data

That's it. Worked for me with Postgres 9.2 in /usr/local/pgsql. The user was able to access Postgres, and replication was not interrupted.

Bookmark and Share

Legal Notices