Re: [PATCHES] pg_standby
От | Doug Knight |
---|---|
Тема | Re: [PATCHES] pg_standby |
Дата | |
Msg-id | 1169046600.13711.1.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: [PATCHES] pg_standby ("Merlin Moncure" <mmoncure@gmail.com>) |
Ответы |
Re: [PATCHES] pg_standby
|
Список | pgsql-patches |
I confirm that I am seeing the exact same characteristic. Could you post your rotating script?
Thanks,
Doug
On Wed, 2007-01-17 at 10:05 -0500, Merlin Moncure wrote:
Thanks,
Doug
On Wed, 2007-01-17 at 10:05 -0500, Merlin Moncure wrote:
On 12/28/06, Simon Riggs <simon@2ndquadrant.com> wrote: > On Thu, 2006-12-28 at 19:26 +0000, Simon Riggs wrote: > > On Thu, 2006-12-14 at 12:04 +0000, Simon Riggs wrote: > > > pg_standby and test framework, in separate .tar files > > > > New version (v2), following further testing. > > > > Signal handling not included in this version. > > Signal handling now added, tested and working correctly in version 3, > attached. > > pg_standby is an example program for a warm standby script as discussed > on -hackers: > http://archives.postgresql.org/pgsql-hackers/2006-08/msg00407.php > > Program looks complete and ready for review, to me. I double checked and re-ran all my test and confirmed that pg_standby move (-m) mode is definitely busted in v3 in the sense that a restart of the standby will not resume recovery and requires a pg_resetxlog to become operational -- it needs one more WAL file back than the oldest one available. I am currently working around this by rotating WAL files a couple of versions back in the shell script I am using to receive log files via netcat. move mode is very desirable because it keeps the maintenance down for the standby system. merlin
В списке pgsql-patches по дате отправления: