"Chris" <christoph.sprin...@magicinternet.de> writes: > A Hot-Standby database is being backed up to a new machine like this:
> 0. pause WAL file deletion from Hot-Standby > 1. backup pg_control > 2. sync data and tablespace files > 3. wait for checkout using pg_controldata and waiting for UNDO address > change > 4. copy all WAL files > 5. recover the newly created database using WAL files This process seems almost entirely unrelated to the documented way of doing it; I'm not surprised that you end up with some files not in sync. Please see pg_start_backup and friends. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs