Re: Backup setup

[Terry Lee Tucker <terry(at)chosen-ones(dot)org>]

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
terry(at)turbocorp(dot)com
www.turbocorp.com