pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWall replay
2+ messages / 2 participants
[nested] [flat]
* Wall replay
@ 2013-04-11 21:01 Keith Ouellette <Keith.Ouellette@Airgas.com>
0 siblings, 1 reply; 2+ messages in thread
From: Keith Ouellette @ 2013-04-11 21:01 UTC (permalink / raw)
To: pgsql-admin
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.
Thanks you in advance.
Keith
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Wall replay
@ 2013-04-11 21:55 Tom Lane <tgl@sss.pgh.pa.us>
parent: Keith Ouellette <Keith.Ouellette@Airgas.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2013-04-11 21:55 UTC (permalink / raw)
To: Keith Ouellette <Keith.Ouellette@Airgas.com>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-04-11 21:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-04-11 21:01 Wall replay Keith Ouellette <Keith.Ouellette@Airgas.com>
2013-04-11 21:55 ` Tom Lane <tgl@sss.pgh.pa.us>
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