Scott Ribe <[email protected]> writes:
> Unless I misread his earlier post, he is starting the backup, copying files,
> stopping the backup, and expecting those transactions (between start & stop)
> to be applied, even though files changed during that time (including WAL
> files) have not all been copied. Again, unless I misread his earlier post, he
> is *not* copying WAL that was generated between start & stop.
If that's the case, it just plain won't work. You can either shut down
the postmaster and copy a static set of files, or you can apply WAL to a
base backup that was taken from a live database. There is no way to get
consistent results from a backup of a live database without applying all
the WAL that was generated while the backup was being taken.
regards, tom lane
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
