Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Incremental backups


  • From: Kev <kevinjamesfield(at)gmail(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Re: Incremental backups
  • Date: 19 Apr 2007 06:41:54 -0700
  • Message-id: <1176990114(dot)774567(dot)11440(at)b75g2000hsg(dot)googlegroups(dot)com>

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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group