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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
