From: | Michael Brusser <michael(at)synchronicity(dot)com> |
---|---|
To: | Pgsql-Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | pg_ctl reload - is it safe? |
Date: | 2003-10-11 03:07:59 |
Message-ID: | DEEIJKLFNJGBEMBLBAHCAEGLDMAA.michael@synchronicity.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Env: Postgres 7.3.4 on Unix
I have a script to create a new database user and update pg_hba.conf.
I was wondering whether I need to restart server, or simply run pg_ctl
reload.
The question is what happens to all active clients when all backends get the
signal.
I ran such client process which was very busy querying and updating
database.
At the same time I kept executing "pg_ctl reload". Soon after client
reported
database error.
Here's the excerpt from the database log:
... ...
2003-10-10 22:33:12 LOG: Received SIGHUP, reloading configuration files
<25 successful SIGHUPs, about 2 seconds apart from each other>
... ...
2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
Interrupted system call
...
From the client log I see that problem occured while trying to SELECT
nextval from
sequence s_noteimportlinks
We are going to pass this script to the customers and we have to know what
to recommend:
reload or shut down/restart. I hope they won't do reload 25 times... but
they may have
25 or more active client processes at any time.
Thanks in advance,
Mike.
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2003-10-11 04:37:53 | Re: 2-phase commit |
Previous Message | Christopher Browne | 2003-10-11 02:54:31 | Re: 2-phase commit |