Restarting recovery mode with pg_standby after failure
Restarting recovery mode with pg_standby after failure
От:
Paul Gross <pgross@gmail.com>
Дата:
We are using pg_standby to consume WAL files from another postgres server. Both servers are running 8.4 on ubuntu lucid. One of the WAL files had incorrect permissions: running restore :cp: cannot open `/some/path/ 00000001000000E700000081' for reading: Permission denied It looks like pg_standby hit this error, stopped recovery, and brought up the database. I can fix the permissions on this one file. My question is if there is a way to restart recovery mode and have the database pick up on the WAL file where it left off. When I put the recovery.conf back, it starts looking for WAL files in timeline 2. If I manually specify recovery_target_timeline to '00000001', I get an error about child timelines. Do I have to re-sync the data files, or can I start recovery again with the existing WAL files? Thanks, Paul Gross
Re: Restarting recovery mode with pg_standby after failure
От:
Fujii Masao <masao.fujii@gmail.com>
Дата:
On Tue, Mar 22, 2011 at 1:08 AM, Paul Gross wrote: > We are using pg_standby to consume WAL files from another postgres > server. Both servers are running 8.4 on ubuntu lucid. One of the WAL > files had incorrect permissions: > > running restore :cp: cannot open `/some/path/ > 00000001000000E700000081' for reading: Permission denied > > It looks like pg_standby hit this error, stopped recovery, and brought > up the database. I can fix the permissions on this one file. > > My question is if there is a way to restart recovery mode and have the > database pick up on the WAL file where it left off. When I put the > recovery.conf back, it starts looking for WAL files in timeline 2. If > I manually specify recovery_target_timeline to '00000001', I get an > error about child timelines. > > Do I have to re-sync the data files, or can I start recovery again > with the existing WAL files? You need to do the former, i.e., take new base backup and start the standby from that. Otherwise, you cannot rewind the timeline ID. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center