Re: [GENERAL] Interrupted streaming replication

@postgresql.org Subject: Re: [GENERAL] Interrupted streaming replication As long as you have 00010089002C 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 <t

Re: [GENERAL] Interrupted streaming replication

> -Original Message- > Tony Nelson wrote: > > > 2015-12-07 08:24:50 EST FATAL: requested WAL segment > > 00010089002C has already been removed > > > > > > > > Can I simply copy the file from my archive directory back to the WAL > directory? > > I'm

Re: [GENERAL] Interrupted streaming replication

Melvin Davidson wrote: > As long as you have 00010089002C 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. Nice idea ;-) wasn't sure if that works, but yes, nice.

[GENERAL] Interrupted streaming replication

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.

Re: [GENERAL] Interrupted streaming replication

As long as you have 00010089002C 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 wrote: > > > > -Original Message- > >

Re: [GENERAL] Interrupted streaming replication

Tony Nelson wrote: > 2015-12-07 08:24:50 EST FATAL: requested WAL segment 00010089002C > 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

Re: [GENERAL] Interrupted streaming replication

g *Subject:* Re: [GENERAL] Interrupted streaming replication As long as you have 00010089002C 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...@

Re: [GENERAL] Interrupted streaming replication

On 12/07/2015 05:50 AM, Tony Nelson wrote: -Original Message- Tony Nelson wrote: 2015-12-07 08:24:50 EST FATAL: requested WAL segment 00010089002C has already been removed Can I simply copy the file from my archive directory back to the WAL