PostgreSQL 9.0 Backup & Recovery

Published on May 2, 2011

In PostgreSQL, Backup & Recovery are very user friendly comparing with other database. Many of them won’t agree to this, ok lets not get into debate. Coming to Backups, PostgreSQL does’nt support INCREMENTAL BACKUP, however there are very consistant backup tools and OS level work-around to achieve this goal. My pictorial presentation on PostgreSQL Backup and Recovery gives a complete conceptial idea. Looking into Diagram you can make out which backups can be used to restore or recover.