From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | Anil John <Anil_John(at)sifycorp(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Backup features available for postgres database |
Date: | 2003-04-01 19:38:47 |
Message-ID: | 1049225927.13853.2168.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-01 19:54:18 | Re: lost tables |
Previous Message | Josh Goldberg | 2003-04-01 19:36:11 | Re: lost tables |