Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Interesting streaming replication issue - Mailing list pgsql-general

From Scott Marlowe
Subject Re: [GENERAL] Interesting streaming replication issue
Date
Msg-id CAOR=d=2DUDi2cvAXuYxW-o7b4nR_bO74UA+Wm=X9sDzfE+dadg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Interesting streaming replication issue  (James Sewell <james.sewell@jirotech.com>)
Responses Re: [GENERAL] Interesting streaming replication issue  (James Sewell <james.sewell@jirotech.com>)
List pgsql-general
Tree view
On Wed, Jul 26, 2017 at 11:55 PM, James Sewell <james.sewell@jirotech.com> wrote:
On Thu, Jul 27, 2017 at 4:41 PM, Gunnar "Nick" Bluth <gunnar.bluth@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 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?

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: [GENERAL] RETURNS SETOF RECORD with 1 column
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] RETURNS SETOF RECORD with 1 column