Reloading postgreSQL without breaking current connection?

Question

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

On a side note, 8.3 is unsupported and you should look at upgrading. postgresql.org/support/versioning — Craig Ringer
– Craig Ringer, Commented Feb 28, 2013 at 23:24

codename32 · Accepted Answer · 2013-02-28 18:52:40Z

8

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.

answered Feb 28, 2013 at 18:52

codename32

2012 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Craig Ringer Over a year ago

Correct, pg_ctl reload doesn't break connections. A restart will.

ypercubeᵀᴹ Over a year ago

And it reads all conf files, (eg pg_hba.conf as well), not just postgresql.conf.

Collectives™ on Stack Overflow

Reloading postgreSQL without breaking current connection?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related