As long as you have 00000001000000890000002C and the subsequent WALs in your archive directory, then you should be able to simply scp them to you second slave's pg_xlog directory.
On Mon, Dec 7, 2015 at 8:50 AM, Tony Nelson <tnel...@starpoint.com> wrote: > > > > -----Original Message----- > > Tony Nelson <tnel...@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 backup is 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 refresher course on exactly what I need to do. > > 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, 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. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
