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

Online Backups: Minor Caveat, Major Addition?

From: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Online Backups: Minor Caveat, Major Addition?
Date: 2006-03-20 15:54:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
I just completed my first online backup and recovery cycle in a test  

I encountered a minor hiccup at step 8 of the process outlined in the  
docs in 23.3.3, "Recovering with an On-line Backup": 

A base backup taken from a running postmaster will still include a file, which will prevent a new postmaster from being  
able to be started.

As a quick fix, a note could be added to item 4 of the recovery  
process that reads something like the following:

Note: If you are recovering to a new cluster and your base backup was  
taken from a running postmaster, you will need to remove if it exists in order to start the new postmaster.

In reviewing this section of the documentation, though, I'm wondering  
if it might not be more clearly broken into 3 further subsections. I  
would suggest: - Inline (or In-place) Recovery - Remote Recovery or Recovery into a New Cluster - Continuous Recovery

The "Inline Recovery" section would just be the existing 23.3.3  

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.


I'd be happy to draft 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,  

Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)


pgsql-docs by date

Next:From: Tom LaneDate: 2006-03-20 22:48:45
Subject: Re: Online Backups: Minor Caveat, Major Addition?
Previous:From: Robert TreatDate: 2006-03-18 07:16:35
Subject: Re: Get docs for contrib on the web somewhere

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