Re: scheduled backup

Apu Islam <apuislam(at)gmail(dot)com> writes:

> I need suggestion to backup my postgresql server. The database is growing
> 1/2 Gb a day and I am looking for a solution that would push the data off
> to the backup server periodically with minimal amount of load to the
> server (I am trying to avoid table locking). I am thinking to use rsync to
> sync the data directories periodically. will that allow me to retrieve the
> data in case of a disaster ? what is the best practise ?

If you're using 8.0.X, you should be able to use rsync along with WAL
shipping to save the data files and the WAL files on a remote machine.
You can then use the PITR mechanism to restore if you need to--see the
docs.

BTW, pg_dump doesn't lock any tables.

-Doug