Apu Islam <apuislam@gmail.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