[GENERAL] Using cp to back up a database? - Mailing list pgsql-general

Hi,

v8.4.20

This is what the current backup script uses:

/usr/bin/psql -U postgres -c "SELECT pg_start_backup('Incrementalbackup',true);"

cp -r /var/lib/pgsql/data/* $dumpdir/data/

/usr/bin/psql -U postgres template1 -c "SELECT pg_stop_backup();"

Should it use rsync or pg_dump instead?

Thanks

-- 
World Peace Through Nuclear Pacification