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

Re: 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: Re: Online Backups: Minor Caveat, Major Addition?
Date: 2006-03-23 04:54:15
Message-ID: 26B5175F-27F6-485E-8B44-2B2BE109D795@sitening.com (view raw or flat)
Thread:
Lists: pgsql-docs
On Mar 20, 2006, at 5:21 PM, Scott Marlowe wrote:

> On Mon, 2006-03-20 at 17:12, Tom Lane wrote:
>> "Thomas F. O'Connell" <tfo(at)sitening(dot)com> writes:
>>> What about the larger suggested change of breaking that section into
>>> three more granular subsections? I could see commentary being
>>> slightly more helpful for each.
>>
>> No particular opinion from here.
>>
>> Someone (was it Scott Marlowe?)  recently volunteered to draft a
>> complete restructuring of the admin docs --- so it would probably be
>> better to think about this as part of that effort rather than a
>> standalone change.
>
> That was me, and I'm working on it right now, in the background.
>
> If anyone has any input, I'd be glad to hear it.  I'm still getting
> docbooks setup on my laptop and such...

Well, my input is to break 23.3.3 out into 3 practical scenarios:

1) recovery (same-server)
2) one-time (or occasional) remote backup
3) continuous recovery

I just noticed another caveat for remote recovery: disable  
archive_command in the postgresql.conf from the filesystem-level backup.

--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC

http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)

In response to

pgsql-docs by date

Next:From: Oisin GlynnDate: 2006-03-23 15:08:40
Subject: COPY command documentation
Previous:From: Robert TreatDate: 2006-03-22 21:50:20
Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z

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