At 15:16 25/06/2012, you wrote:
On 6/25/2012 7:35 AM, Eduardo Morras wrote:
Hi everyone,
I'm using FreeBSD 9 for Postgres and want to know if these actions
are safe for make a backup of the database:
a) call pg_start_backup('b1')
b) take an UFS2 snapshot of data files
c) call pg_stop_backup()
d) change to the snapshot dir and rsync/dd/dump/transfer it to
backup file server
Is it safe to call pg_start_backup('b1',true)?
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
