Re: Online Backups: Minor Caveat, Major Addition? - Mailing list pgsql-docs

From Thomas F. O'Connell
Subject Re: Online Backups: Minor Caveat, Major Addition?
Date
Msg-id 26B5175F-27F6-485E-8B44-2B2BE109D795@sitening.com
Whole thread Raw
In response to Re: Online Backups: Minor Caveat, Major Addition?  (Scott Marlowe <smarlowe@g2switchworks.com>)
List 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@sitening.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)

pgsql-docs by date:

Previous
From: Robert Treat
Date:
Subject: Re: ALTER TABLE x ALTER COLUMN y TYPE z
Next
From: David Fetter
Date:
Subject: Re: [GENERAL] COPY command documentation