On Tue, Mar 22, 2011 at 1:08 AM, Paul Gross <pgross@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
