Re: Standby problem after restore_command Implementation

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Edson F(dot) Lidorio" <edson(at)openmailbox(dot)org>, Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Standby problem after restore_command Implementation
Date: 2015-05-05 17:31:36
Message-ID: 5548FE78.9090305@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/05/2015 08:35 AM, Edson F. Lidorio wrote:
> On 05-05-2015 11:22, Melvin Davidson wrote:
>> It's possible you have wal_keep_segments set too low. What happens is
>> that the master will keep the wals ( in your case 20) after processing
>> them, before sending them off to the great black hole in the network
>> (deleting) and making them unavailable to the standby. Try increasing
>> wal_keep_segments = 100.
>>

> Increased thewal_keep_segments=100andkeeps popping upthe same message:

The message did not come through. Also increasing wal_keep_segments only
works for the future, it will not deal with a WAL file that has already
been recycled before the setting was changed.

>
> A question thatI have!
> astheslave servercan seethis folderin themaster?
> /mnt/server/archivedir/
>

So have you tried logging into the standby and then accessing the
directory on the master manually. In other words copy a file from the
master to standby using cp from the standby command line.

> Sorrymy doubtsI'mbasicbeginner!

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Fournier 2015-05-05 17:41:35 Re: PGFoundry Sample databases (particularly world)?
Previous Message Hub.Org Support 2015-05-05 17:23:40 Re: PGFoundry Sample databases (particularly world)?