Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Reloading postgreSQL without breaking current connection?

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

like image 447
codename32 Avatar asked Feb 28 '13 17:02

codename32


1 Answers

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.

like image 175
codename32 Avatar answered Oct 13 '22 00:10

codename32