Re: Backup features available for postgres database

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