Re: [HACKERS] SIGHUP during recovery

2009-03-05 Thread Simon Riggs
On Wed, 2009-03-04 at 15:58 +0200, Heikki Linnakangas wrote: Fujii Masao wrote: Currently, the startup process ignores SIGHUP. The attached patch allows the startup process to re-read config file: when SIGHUP arrives, the startup process also receives the signal from postmaster and

Re: [HACKERS] SIGHUP during recovery

2009-03-05 Thread Fujii Masao
Hi, On Thu, Mar 5, 2009 at 6:28 PM, Simon Riggs si...@2ndquadrant.com wrote: Should we reload recovery.conf also? I think no for now. At least the parameters which specify the recovery target should not be changed during recovery. On the other hand, restore_command maybe can be set safely, but

Re: [HACKERS] SIGHUP during recovery

2009-03-05 Thread Simon Riggs
On Thu, 2009-03-05 at 19:52 +0900, Fujii Masao wrote: Hi, On Thu, Mar 5, 2009 at 6:28 PM, Simon Riggs si...@2ndquadrant.com wrote: Should we reload recovery.conf also? I think no for now. At least the parameters which specify the recovery target should not be changed during recovery.

Re: [HACKERS] SIGHUP during recovery

2009-03-05 Thread Heikki Linnakangas
Simon Riggs wrote: On Thu, 2009-03-05 at 19:52 +0900, Fujii Masao wrote: Hi, On Thu, Mar 5, 2009 at 6:28 PM, Simon Riggs si...@2ndquadrant.com wrote: Should we reload recovery.conf also? I think no for now. At least the parameters which specify the recovery target should not be changed

Re: [HACKERS] SIGHUP during recovery

2009-03-05 Thread Heikki Linnakangas
Fujii Masao wrote: BTW, I found that backup.sgml still had the description of log_restartpoints. Here is the patch to remove it. Thanks, I had put that in the Open Items list so that we remember to do that before release. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] SIGHUP during recovery

2009-03-05 Thread Tom Lane
Fujii Masao masao.fu...@gmail.com writes: BTW, I found that backup.sgml still had the description of log_restartpoints. Here is the patch to remove it. Applied, thanks. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] SIGHUP during recovery

2009-03-04 Thread Heikki Linnakangas
Fujii Masao wrote: Currently, the startup process ignores SIGHUP. The attached patch allows the startup process to re-read config file: when SIGHUP arrives, the startup process also receives the signal from postmaster and reload the settings in main redo apply loop. Obviously, this is useful to

[HACKERS] SIGHUP during recovery

2009-03-02 Thread Fujii Masao
Hi, Currently, the startup process ignores SIGHUP. The attached patch allows the startup process to re-read config file: when SIGHUP arrives, the startup process also receives the signal from postmaster and reload the settings in main redo apply loop. Obviously, this is useful to change the