Search Postgresql Archives

Re: Incremental backups

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Apr 19, 9:41 am, Kev <kevinjamesfi...@xxxxxxxxx> wrote:
> On Apr 17, 10:27 am, j_mageshwa...@xxxxxxxxxxxx (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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux