Interrupted streaming replication

From: Tony Nelson <tnelson(at)starpoint(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Interrupted streaming replication
Date: 2015-12-07 13:25:08
Message-ID: 8EA37B362510F041843410BA815C044DCAE0A32CB7@NYMBXCLUS.WIN.STARPOINT.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I have a small problem of my own making. I have a simple streaming replication setup, one master and two slaves. One slave is in the same rack as the master, the other is across a "slow" link in another server room.

Last night I executed some updates that caused a lot of changes. The slave in the same room did worked just fine, and the slave across the slow link was working fine, applying logs.

Then my backups executed, and moved all of the WAL archives, to an archive directory.

The good news is, I *think* I have them all.

The slave is waiting:

postgres 12562 12561 0 Oct16 ? 00:11:07 postgres: startup process waiting for 00000001000000890000002C

And I definitely have the file in my archive directory on the master.

The master is logging this error:

2015-12-07 08:24:50 EST FATAL: requested WAL segment 00000001000000890000002C has already been removed

Can I simply copy the file from my archive directory back to the WAL directory?

Thanks in advance
Tony Nelson

________________________________
Since 1982, Starpoint Solutions has been a trusted source of human capital and solutions. We are committed to our clients, employees, environment, community and social concerns. We foster an inclusive culture based on trust, respect, honesty and solid performance. Learn more about Starpoint and our social responsibility at http://www.starpoint.com/social_responsibility

________________________________
This email message from Starpoint Solutions LLC is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Opinions, conclusions and other information in this message that do not relate to the official business of Starpoint Solutions shall be understood as neither given nor endorsed by it.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2015-12-07 13:45:33 Re: Interrupted streaming replication
Previous Message Tim Smith 2015-12-07 11:57:02 Re: JDBC and inet type