PostgreSQL backups

Alex Dean alex at crackpot.org
Thu Dec 1 21:47:32 MST 2005


On Dec 1, 2005, at 8:35 PM, Bart Garst wrote:

> We have a lot of data in our database. We obviously need to back it  
> up.
> Doing a complete dump every day is not going to work for us.

How much is 'a lot'?  GB, TB, +++?

For free solutions, the only thing I've ever done is a daily SQL  
dump, and that's worked flawlessly.

If that's really not an option, Arkiea isn't cheap, but they have a  
plugin allowing you to backup a running PostgreSQL database.  I  
imagine it might be able to do incremental backups as well?  http:// 
www.arkeia.com/pr/pr_20041209.html

alex
.





More information about the PLUG-discuss mailing list