An overview of PostgreSQL's backup, archiving and replication
The PostgreSQL documentation explains in detail how to do backup and replication, maybe too detailed for beginners or "part-time" DBAs.
On the other hand, there are some common misconceptions about data safety.
The talk gives a comprehensive, yet brief overview of the different approaches to perform backup/restore, point-in-time recovery and replication, advising on what to use in different scenarios.
Some typical misconceptions and pitfalls are addressed as well.
|Gunnar Bluth (Nick)|