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 ?