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
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)? |