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

Re: Online Backups: Minor Caveat, Major Addition?

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Online Backups: Minor Caveat, Major Addition?
Date: 2006-03-22 13:33:28
Message-ID: 20060322133328.GE15742@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-docs
On Mon, Mar 20, 2006 at 09:54:53AM -0600, Thomas F. O'Connell wrote:
> 23.3.3.1 - Inline (or In-place) Recovery
> 23.3.3.2 - Remote Recovery or Recovery into a New Cluster
> 23.3.3.3 - Continuous Recovery
> 
> The "Inline Recovery" section would just be the existing 23.3.3  
> repurposed.
> 
> The "Remote/New Cluster Recovery" section would be an edited version  
> of the existing 23.3.3 to eliminate step1 and include the note  
> suggested above.
> 
> The "Continuous Recovery" section would include details of how to  
> continuously apply WAL files to a separate cluster in order to have a  
> true hot standby system.
> 
> Thoughts?
> 
> I'd be happy to draft 23.3.3.2. I'll have to figure out how to  
> implement Simon Riggs's suggestion of a wait-for-files  
> recover_command including a way to interrupt in the event of a need  
> for actual failover-style recovery before I could draft 23.3.3.3,  
> though.

BTW, when it comes to continuous recovery you should have a look at
http://pgfoundry.org/projects/pgpitrha/
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

pgsql-docs by date

Next:From: Kevin GrittnerDate: 2006-03-22 17:58:13
Subject: ALTER TABLE x ALTER COLUMN y TYPE z
Previous:From: Scott MarloweDate: 2006-03-20 23:21:50
Subject: Re: Online Backups: Minor Caveat, Major Addition?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group