On Jan 3, 2011, at 11:22 AM, Imre Oolberg wrote:

> But http://www.postgresql.org/docs/9.0/interactive/continuous-archiving.html 
> suggests to use tar on rsync and i guess that PostgreSQL recovery with wal 
> files takes care of these inconsistencies that are created during copying 
> filesystem, right?

Yes, but the database is recovered to the consistent state as of the 
pg_start_backup command, as I pointed out to you before. Results of 
transactions that commit after the pg_start_backup command will not be in the 
backed up database.

-- 
Scott Ribe
[email protected]
http://www.elevated-dev.com/
(303) 722-0567 voice





-- 
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to