From: Tom Lane <tgl@sss.pgh.pa.us>
To: Keith Ouellette <Keith.Ouellette@Airgas.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Wall replay
Date: Thu, 11 Apr 2013 17:55:34 -0400
Message-ID: <12450.1365717334@sss.pgh.pa.us> (raw)
In-Reply-To: <417C5AF7C228B94490192951394BEFE7AF396A@AIPHLEXDAG01B.airgas.com>
References: <417C5AF7C228B94490192951394BEFE7AF396A@AIPHLEXDAG01B.airgas.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Keith Ouellette <Keith.Ouellette@Airgas.com> writes:
> I am realatively new to PostgreSQL. I have two servers in a Master/Slave relationship using WAL as the replication method. I have what I hope to be an easy question. If the Master goes down and before the slave is promoted, there may be a case where a log file may not have been shipped to the slave yet. If the new Master starts to process new transactions, is there a way to have it process the unshipped WAL files if they are copied to it? I do not see that case in the documentation.
You'd have to ship the remaining WAL over *before* the slave has come
up live, else it's too late.
If you're concerned about gaps of that sort, though, you should not be
using log file shipping at all. Set up streaming replication instead.
(If the PG version you're using hasn't got that, high time to move
to something newer.)
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: tgl@sss.pgh.pa.us, Keith.Ouellette@Airgas.com
Subject: Re: Wall replay
In-Reply-To: <12450.1365717334@sss.pgh.pa.us>
* 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