On Wednesday 23 April 2008 11:14, Gabor Siklos wrote: > I need to back up our database off-site for disaster recovery. If I just > back up the entire database data directory (i.e. /var/lib/pgsql/data) will > I be able to restore from there? Or should I instead just dump the data, > using pg_dump, and back up the dump? > The advantage of the first method would be that I would not have to wait > for pg_dump (it takes quite long on our 60G+ database) and would just be > able to configure the backup agent to monitor the data directory and do > differential backups of the files there every hour or so. > Your suggestions are much appreciated! > -Gabor
I would use pg_dump. It will ensure that you get a complete set of data and not something half written. -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6987 [EMAIL PROTECTED] www.turbocorp.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
