Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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 postgresql-backup.com – Olek Nilson May 5 at 11:50
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .