Re: Warm standby problems

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.