Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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 (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
