Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Incremental Backup Script
- From: Simon Riggs <simon(at)2ndquadrant(dot)com>
- To: Gregor Zeitlinger <gregor(dot)zeitlinger(at)torexretail(dot)de>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Incremental Backup Script
- Date: Mon, 26 Dec 2005 11:04:26 +0000
- Message-id: <1135595066(dot)2964(dot)660(dot)camel(at)localhost(dot)localdomain>
On Sun, 2005-12-25 at 14:02 +0100, Gregor Zeitlinger wrote: > as far as I have understood, the WAL backup that you control via > "archive_command" is the PostgreSQL equivalent to what other databases > let you do with an incremental backup No it is not an incremental backup of changed data blocks, it is a transactional log archival. So, other parts of your thinking are slightly off - but not by much. The only way to do a partial recovery is to follow the PITR notes. Best Regards, Simon Riggs
- References:
- Incremental Backup Script
- From: Gregor Zeitlinger
- Incremental Backup Script
- Prev by Date: Re: [PATCHES] default resource limits
- Next by Date: Re: Fixing row comparison semantics
- Previous by thread: Re: Incremental Backup Script
- Next by thread: Improving "missing FROM-clause entry" message
- Indexes: