On Tue, Jan 26, 2010 at 8:54 PM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > Simon Riggs wrote: >> Currently, we had presumed >> that standby_mode = off would be the same as Warm Standby replication, >> using pg_standby or other. > > That's still true. standby_mode=off is the same as what you have in PG > 8.4. You can still use pg_standby etc. with that. > >> pg_standby checks file size before returning. If you just use "cp" as >> suggested then it would fail because the copy would start before the >> file is ready to be copied. > > True. You could work around that by using a script instead of plain > 'cp', or by making sure that no partial files appear in the archive in > the other end.
How about just retrying SR instead of emitting a FATAL error in RestoreArchivedFile() when a partial WAL file has been restored? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers