Re: Interesting streaming replication issue

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: James Sewell <james(dot)sewell(at)jirotech(dot)com>
Cc: Gunnar Nick Bluth <gunnar(dot)bluth(at)pro-open(dot)de>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Interesting streaming replication issue
Date: 2017-07-27 12:58:35
Message-ID: CAOR=d=2DUDi2cvAXuYxW-o7b4nR_bO74UA+Wm=X9sDzfE+dadg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 26, 2017 at 11:55 PM, James Sewell <james(dot)sewell(at)jirotech(dot)com>
wrote:

> On Thu, Jul 27, 2017 at 4:41 PM, Gunnar "Nick" Bluth <
> gunnar(dot)bluth(at)pro-open(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-07-27 14:03:22 Re: RETURNS SETOF RECORD with 1 column
Previous Message Vincenzo Romano 2017-07-27 11:27:58 RETURNS SETOF RECORD with 1 column