Apu Islam <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
