Search Postgresql Archives

Interrupted streaming replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux