Re: [GENERAL] Interesting streaming replication issue

Hi, On 2017-07-27 13:00:17 +1000, James Sewell wrote: > Hi all, > > I've got two servers (A,B) which are part of a streaming replication pair. > A is the master, B is a hot standby. I'm sending archived WAL to a > directory on A, B is reading it via SCP. > > This all works fine normally. I'm on

Re: [GENERAL] Interesting streaming replication issue

OK this is reproducible now. 1. Stop a standby 2. Write some data to the master 3. Wait till the master has archived some WAL logs 4. Wait till the archived logs have been removed from pg_xlog 5. Start the standby. The standby will recover all logs from the master log archive up

Re: [GENERAL] Interesting streaming replication issue

> > >> >>> are you sure you're scp'ing from the archive, not from pg_xlog? >>> >> >> Yes: >> >> restore_command = 'scp -o StrictHostKeyChecking=no >> 10.154.19.30:/archive/xlog//%f >> %p' >> >> Although you are right - that would almost make sense if I had done that! >> > > Sounds a lot like a

Re: [GENERAL] Interesting streaming replication issue

On Wed, Jul 26, 2017 at 11:55 PM, James Sewell wrote: > On Thu, Jul 27, 2017 at 4:41 PM, Gunnar "Nick" Bluth < > gunnar.bl...@pro-open.de> wrote: > >> >> are you sure you're scp'ing from the archive, not from pg_xlog? >> > > Yes: > > restore_command = 'scp -o

Re: [GENERAL] Interesting streaming replication issue

On Thu, Jul 27, 2017 at 4:41 PM, Gunnar "Nick" Bluth < gunnar.bl...@pro-open.de> wrote: > > are you sure you're scp'ing from the archive, not from pg_xlog? > Yes: restore_command = 'scp -o StrictHostKeyChecking=no 10.154.19.30:/archive/xlog//%f %p' Although you are right - that would almost

Re: [GENERAL] Interesting streaming replication issue

(sorry for the top post, bitchy K9 Mail) James, are you sure you're scp'ing from the archive, not from pg_xlog? Regards, Gunnar "Nick" Bluth Am 27. Juli 2017 05:00:17 MESZ schrieb James Sewell : >Hi all, > >I've got two servers (A,B) which are part of a