On Apr 19, 9:41 am, Kev <[EMAIL PROTECTED]> wrote:
> On Apr 17, 10:27 am, [EMAIL PROTECTED] (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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

Reply via email to