Am Freitag, den 21.10.2005, 12:22 -0500 schrieb Apu Islam: > 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 have big amount of data changes, continous backup of the WAL files for point-in-time recovery is probably a good solution. Especially if you can afford a 2nd box where the data is continously replayed. See: http://www.postgresql.org/docs/current/static/backup-online.html ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
