Re: pg_stat_replication became empty suddenly

Thanks. I increased the wal_keep_segments  and it works well now.

On 7 Aug 2013, at 12:43 AM, Jerry Sievers wrote:

> "ascot.moss@gmail.com" <ascot.moss@gmail.com> writes:
>
>> Hi,
>>
>> I just tried another round of tests, without running  "sync; echo 3 > /proc/sys/vm/drop_caches',
>> still got the same error,  following FATAL errors are found in pg_log (slave), can anyone please advise how to
resolve
>> this error?
>>
>> regards
>>
>> LOG:  entering standby mode
>> LOG:  consistent recovery state reached at 11/42000318
>> LOG:  redo starts at 11/42000280
>> LOG:  invalid record length at 11/42000318
>> LOG:  database system is ready to accept read only connections
>> LOG:  streaming replication successfully connected to primary
>> FATAL:  could not send data to WAL stream: server closed the connection unexpectedly
>> This probably means the server terminated abnormally
>> before or while processing the request.
>> LOG:  unexpected pageaddr 10/D2EC0000 in log file 18, segment 5, offset 15466496
>> LOG:  streaming replication successfully connected to primary
>> FATAL:  could not receive data from WAL stream: FATAL:  requested WAL segment 000000010000001200000005 has already
>> been removed
>> LOG:  streaming replication successfully connected to primary
>> FATAL:  could not receive data from WAL stream: FATAL:  requested WAL segment 000000010000001200000005 has already
>
> Raise wal_keep_segments on your master configs ,and HUP and/or start
> your standby a lot sooner after it's reloaded.
>
> <snip>
>>
>
> --
> Jerry Sievers
> Postgres DBA/Development Consulting
> e: postgres.consulting@comcast.net
> p: 312.241.7800