Re: Incremental backups - Mailing list pgsql-general

From Kev
Subject Re: Incremental backups
Date
Msg-id 1176991616.382670.199370@l77g2000hsb.googlegroups.com
Whole thread Raw
In response to Re: Incremental backups  (Kev <kevinjamesfield@gmail.com>)
List pgsql-general
On Apr 19, 9:41 am, Kev <kevinjamesfi...@gmail.com> wrote:
> On Apr 17, 10:27 am, j_mageshwa...@sifycorp.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

Actually, check out WAL archiving, that might be more appropriate.  I
don't know much about it though.

Kev



pgsql-general by date:

Previous
From: Germán Hüttemann Arza
Date:
Subject: Auditing a database
Next
From: Reid Thompson
Date:
Subject: Re: Postgres data/form entry tool