On Jun 25, 2012, at 10:34 AM, Eduardo Morras wrote: >>> Thanks in advance >> Snapshots are "safe" (but will result in a roll-forward on restart) IF AND >> ONLY IF the log data and database table spaces are all on the same >> snapshotted volume. >> >> IF THEY ARE NOT then it will probably work 95% of the time, and the other 5% >> it will be unrecoverable. Be very, very careful -- the snapshot must in >> fact snapshot ALL of the involved database volumes (log data included!) at >> the same instant. > > Even if i do a pg_start_backup()? I thought it set db data/ files in a > consistent state and puts in wal files the new transactions and apply them > when call pg_stop_backup(). > > I must do it other way then :( > > Thanks
If you are doing pg_start_backup(), taking snapshot and pg_stop_backup with archived WAL file backups. Then its safe. Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company Blog: http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
