Originally posted by liu0130
Disaster recovery for PostgreSQL how to?
What backup software support PostgreSQL and disaster recovery?
My servser is Sun fire 280R(sparc 64).
Not sure what others do, nor if what I do is best. I have a relatively small database of just over 11GB (that is small compared to several oracle databases we have here at work). Anyhow, this is what I do:
- Each night, shut down the database as the server is backed up. I am using Amanda http://www.amanda.org/ and backing up this server through the network to another linux server that is attached to a MTI tape robot (that has DLT tape drives in it). The Amanda backups automagically run at level 0, 1, 2, etc based on the tape rotation parameters I set.
- Once a week perform a 'pg_dumpall', piping the output to gzip and writing the output file to a NFS server mount that is HUGE.
Anyhow, that is most likely not the best option, but the data we're storing (statistical system performance data) is not business critical - thus if we had a disaster and lost a week's worth of data, no-one will lose sleep (or money) over it.