On Fri, Jun 13, 2014 at 5:08 PM, Kyotaro HORIGUCHI <horiguchi.kyot...@lab.ntt.co.jp> wrote: > Hello, this is a patch that add the function to clear backup > location information to pg_resetxlog. > > As per the discussion held before, this function cannot be back > patched to the older versions than 9.4. And it also slipped over > 9.4 so proposed in this CF. > > This simplly erases the backup location information in pg_control > written during recovery. This is seen as the output of > pg_controldata. > > | $ pg_controldata > | pg_control version number: 942 > | Catalog version number: 201406121 > | ... > !| Backup start location: 0/0 > !| Backup end location: 0/0 > !| End-of-backup record required: no > | ... > > Under some condition, this values sticks having valid values even > though the WAL record which indicates the end of backup won't > come. This option could be used to forcibly finish the blocked > recovery procedure.
The document about pg_resetxlog needs to be updated. I think that pg_resetxlog should reset backup locations by default since they are useless (rather harmful) after pg_resetxlog. Thought? Regards, -- Fujii Masao -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers