Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm looking for a way to make good incremental backups for a large (more than 100 GB) PostgreSQL 8.3 DB. I'm currently using pg_dump which isn't incremental and very slow in backup and restore, because it dumps the entire contents every time.

I thought pg_rman would be the answer, but it's working on requires PostgreSQL 8.4 or newer.

Any ideas?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

http://code.google.com/p/pg-rman/

Appears to solve this problem

share|improve this answer

This is a question better asked and answered on serverfault.com - in fact: http://serverfault.com/questions/55661/automatic-postgres-backup discusses a few options around backups.

What you probably want are online backups - have a look at the docs:

http://www.postgresql.org/docs/8.1/static/backup-online.html

share|improve this answer
    
They discuss pg_dump and pg_dumpall, nothing incremental. –  Adam Matan Jan 11 '10 at 16:46
    
this doesn't answer the question –  Scott Schulthess Jun 29 '11 at 14:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.