Incremental Backup for PostgreSQL 8.3

Question

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?

Answer 1

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

Appears to solve this problem

Answer 2

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