From: Ray Stell <stellr@cns.vt.edu>
To: pgsql-admin@postgresql.org
Subject: streaming AND file-based log-shipping?
Date: Thu, 14 Apr 2011 21:25:00 -0400
Message-ID: <20110415012500.GA9121@cns.vt.edu> (raw)
The cookbook text says, log shipping "is mostly superseded by streaming
replication in 9.0, though is still useful as part of a comprehensive
backup strategy." The implication is that the WAL archive might be
needed for recovery in some cases:
1. Under what circumstances might the WAL archive come into play in recovery?
2. If the streaming rep fails for some reason will the standby begin
recovery from the WAL archive, assuming the WAL can still be shipped?
3. What query or command set can be used to tell if file-based recovery is
configured correctly if streaming replication is active?
I've configured both (I think), but it isn't clear to me whether
the file-based part will function. I guess I could bust the stream somehow
and see what happens, but I can't find this idea documented.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stellr@cns.vt.edu
Subject: Re: streaming AND file-based log-shipping?
In-Reply-To: <20110415012500.GA9121@cns.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox