Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
You can try this tool for making scheduled backups – Olek Nilson May 5 at 11:50
up vote 1 down vote accepted

Appears to solve this problem

share|improve this answer

This is a question better asked and answered on - in fact: discusses a few options around backups.

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

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


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.