Re: Start Walreceiver completely before shut down it on standby server.

2019-12-11 Thread Michael Paquier
On Wed, Dec 11, 2019 at 04:06:26PM +0800, jiankang liu wrote: > During my use of PG, I encountered such errors "incorrect resource manager > data checksum in record at 0/5013730", > it will keeps printing this error message and never stops on standby > server,at same time, the walreceier process

Re: Start Walreceiver completely before shut down it on standby server.

2019-12-11 Thread jiankang liu
andby server. So, we can fix the problem online and the walreceiver will not be lost. Kyotaro Horiguchi 于2019年12月11日周三 下午1:38写道: > At Tue, 10 Dec 2019 10:40:53 -0800, Ashwin Agrawal > wrote in > > On Tue, Dec 10, 2019 at 3:06 AM jiankang liu > wrote: > > > > &

Re: Start Walreceiver completely before shut down it on standby server.

2019-12-10 Thread Kyotaro Horiguchi
At Tue, 10 Dec 2019 10:40:53 -0800, Ashwin Agrawal wrote in > On Tue, Dec 10, 2019 at 3:06 AM jiankang liu wrote: > > > Start Walreceiver completely before shut down it on standby server. > > > > The walreceiver will be shut down, when read an invalid record in th

Re: Start Walreceiver completely before shut down it on standby server.

2019-12-10 Thread Ashwin Agrawal
On Tue, Dec 10, 2019 at 3:06 AM jiankang liu wrote: > Start Walreceiver completely before shut down it on standby server. > > The walreceiver will be shut down, when read an invalid record in the > WAL streaming from master.And then, we retry from archive/pg_wal again. > > Af

Start Walreceiver completely before shut down it on standby server.

2019-12-10 Thread jiankang liu
Start Walreceiver completely before shut down it on standby server. The walreceiver will be shut down, when read an invalid record in the WAL streaming from master.And then, we retry from archive/pg_wal again. After that, we start walreceiver in RequestXLogStreaming(), and read record from