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

At 16:27 28/11/2011, you wrote:

At 19:32 03/08/2011, you wrote:
Yes, this is what happened to me 2-3 years ago. Table had only 1-3
rows but its size is 80-90 Gb. Once the app quits, autovacuum cleaned
the table and became 8KB