Thread: Backup features available for postgres database

Backup features available for postgres database

From
"Anil John"
Date:
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
 

Re: Backup features available for postgres database

From
Robert Treat
Date:
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