On 12/07/2015 05:50 AM, Tony Nelson wrote:
>
>
>> -----Original Message-----
>> Tony Nelson <tnelson@starpoint.com> wrote:
>>
>>> 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?
>>
>> I'm afraid that won't work, because of the master knows nothing about this
>> copy and can't stream its content.
>>
>> Maybe you can create/update your recovery.conf, see restore_command.
>>
>>
>> for the future: increase wal_keep_segments, or better: use replication slots
>> (since 9.4 a really good feature to prevent such errors).
>>
>>
>
> Thank you. I'm still running 9.1, but I'll look into 9.4. Fortunately my database is small so doing a new base
backupis not the end of the world. It's been a long time since I've set this up, so I'm going to have to go through a
refreshercourse on exactly what I need to do.
I have not done it, but is seems to me given that you have an WAL
archive you could enable archive recovery on the stalled slave and
restart it:
http://www.postgresql.org/docs/9.1/interactive/archive-recovery-settings.html
>
> Thanks for your help.
>
> Tony
>
> 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,
honestyand 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
confidentialand privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If
youare 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
StarpointSolutions shall be understood as neither given nor endorsed by it.
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
