Re: Incremental backups

From: Kev <kevinjamesfield(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Incremental backups
Date: 2007-04-19 13:41:54
Message-ID: 1176990114.774567.11440@b75g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Apr 17, 10:27 am, j_mageshwa(dot)(dot)(dot)(at)sifycorp(dot)com (Mageshwaran) wrote:
> hi everyone,
>
> please any one give any methods to do incremental backups. it is urgent
> .. help me
>
> Regards
> J Mageshwaran

Sorry, I don't have anything implemented, but I've been wondering
about this too. One way (not necessarily the best) might be an audit
trail if done in such a way that you could rebuild the entire database
from the audit trail. Then you need only back up the audit entries
since the last backup. However, you have to keep all backups, or once
in a while do a 'fresh start' backup where you take all audit
entries. There's another thread starting about audit trails, you
might want to check there.

Kev

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kev 2007-04-19 14:06:56 Re: Incremental backups
Previous Message Bill Moran 2007-04-19 13:33:14 Re: How often do I need to reindex tables?