Tom Lane wrote: > No; there's no WAL change between 8.3.7 and 8.3.8. What seems more > likely is that you're somehow shipping the WAL files before they're > quite finished.
I doubt it. Our archive_command works like this: 1) scp the file over to the backup server as root. It's stored in a file named <name_of_wal>.NEW 2) When the scp finishes, ssh to the standby server and chown it to postgres. 3) Then, ssh to the standby server and rename the <name_of_wal>.NEW file to the real WAL filename. Only after step (3) does our standby script even see the file. So unless there's a possibility that the master server invokes our archive script before the WAL has finished being written, I can't see how this could happen. Regards, David. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
