1
vote
2answers
294 views

PostgreSQL: Dump consistant state without locking

A good database backup is consistent, so the whole dump represents the state when the dumping was started. A typical strategy for this on MySQL is to lock the table, so no additional data can be ...
3
votes
2answers
4k views

Incremental Backup for PostgreSQL 8.3

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, ...