I was wondering if i issued a reload command to Postgres so that it could reread the pg_hba.conf file (Made some changes in here and need them to take immediate effect on a live system) will destroy or drop and current connections?
/etc/init.d/postgreSQL83 reload
I crossed my fingers and tried this on my own. And, it worked! No connections dropped. So you can actually issue a postgreSQL reload command at the command prompt and it only reads the configuration file. It does not restart the PostgreSQL server nor drop connections.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With