Restarting recovery mode with pg_standby after failure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux