Thread: Backup features available for postgres database
Hi all,
I am using few postgres databases for my applications.
The backup we do is a complete backup.
The problem is that in case recovery is needed it takes around 5-6 hrs for completing the recovery which would down the application for the same period of time.
I would like to get advice from you all, about the different strategies to backup which are available in postgres. (Like logical and physical as well as full, cumulative and incremental backups in oracle)
I would appreciate if you provide me some good site addresses and manual for postgres database.
Thank you,
Anil
On Tue, 2003-04-01 at 00:27, Anil John wrote: > Hi all, > > I am using few postgres databases for my applications. > > The backup we do is a complete backup. > > The problem is that in case recovery is needed it takes around 5-6 hrs > for completing the recovery which would down the application for the > same period of time. > > I would like to get advice from you all, about the different strategies > to backup which are available in postgres. (Like logical and physical as > well as full, cumulative and incremental backups in oracle) > > I would appreciate if you provide me some good site addresses and manual > for postgres database. > Wow, i find it hard to believe you couldn't find any information on this topic, but here's some links: Backup documentation: http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=backup.html Email on Point in Time Recovery Status: http://fts.postgresql.org/db/mw/msg.html?mid=1362267 Interesting thread on using LVM snapshots to do backups http://archives.postgresql.org/pgsql-admin/2003-03/msg00222.php Robert Treat