Geek asks and answers

Rebooting postgreSQL without breaking the current connection?

I was wondering if I issued the reload command for Postgres so that it could re-read the pg_hba.conf file (made some changes here and required an immediate impact on the live system) will the current connections be deleted or deleted?

/etc/init.d/postgreSQL83 reload

+5
source share
1 answer

I crossed my fingers and tried it myself. And it worked! There were no connections. That way, you can actually issue the postgreSQL reload command on the command line, and it only reads the configuration file. It does not restart the PostgreSQL server and does not disconnect connections.

+5
source

More articles:


All Articles