Re: Interesting streaming replication issue

[Scott Marlowe <scott.marlowe@xxxxxxxxx>]

On Wed, Jul 26, 2017 at 11:55 PM, James Sewell <james.sewell@xxxxxxxxxxxx> wrote:

On Thu, Jul 27, 2017 at 4:41 PM, Gunnar "Nick" Bluth <gunnar.bluth@xxxxxxxxxxx> 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 make sense if I had done that!

Sounds a lot like a cleanup process on your archive directory or something getting in the way. Are the logs pg is asking for in that archive dir?