Re: Using cp to back up a database?

If you want a consistent database (you *REALLY* do), pg_dump is the correct tool.

--

Larry Rosenman http://www.lerctr.org/~ler

Phone: +1 214-642-9640 E-Mail: ler(at)lerctr(dot)org

US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106

From: <pgsql-general-owner(at)postgresql(dot)org> on behalf of Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Date: Monday, October 9, 2017 at 8:41 AM
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] Using cp to back up a database?

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