Re: Backups from the standby (Incrementally Updated Backups), open item - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Backups from the standby (Incrementally Updated Backups), open item
Date
Msg-id 201008241808.o7OI8x505603@momjian.us
Whole thread Raw
In response to Backups from the standby (Incrementally Updated Backups), open item  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Backups from the standby (Incrementally Updated Backups), open item
List pgsql-hackers
Josh Berkus wrote:
> All,
> 
> I've been looking at the open item which belongs with this doc:
> 
> http://www.postgresql.org/docs/9.0/static/backup-incremental-updated.html
> 
> ... and my viewpoint is that the procedure described should be *cut*
> from the official docs and put on the Wiki, with warnings.  It's simply
> far too hackish and dependant on DBA understanding of PostgreSQL
> internals to belong in the main docs.
> 
> In 9.1 we'll probably have some machinery to make taking snapshots of
> the standby more reliable (like running pg_start_backup on the master),
> and then that procedure will belong in the main docs.

FYI, I am working on a doc update that will use pg_start/stop backup on
the master, as suggested by Fujii Masao:
http://archives.postgresql.org/pgsql-bugs/2010-08/msg00237.php

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Backups from the standby (Incrementally Updated Backups), open item
Next
From: "David E. Wheeler"
Date:
Subject: Re: EXPLAIN doesn't show the actual function expression for FunctionScan