Re: Critical failure of standby - Mailing list pgsql-general

From Jeff Janes
Subject Re: Critical failure of standby
Date
Msg-id CAMkU=1y0Le5QpZUq8A-Xh-sc5kLYoSZfFWz8aX-KVn3C0DEBCA@mail.gmail.com
Whole thread Raw
In response to Re: Critical failure of standby  (James Sewell <james.sewell@jirotech.com>)
List pgsql-general
On Mon, Aug 15, 2016 at 7:23 PM, James Sewell <james.sewell@jirotech.com> wrote:
Those are all good questions.

Essentially this is a situation where DR is network separated from Prod - so I would expect the archive command to fail.


archive_command or restore_command?  I thought it was restore_command.

 
I'll have to check the script it must not be passing the error back through to PostgreSQL.

This still shouldn't cause database corruption though right? - it's just not getting WALs.

If the WAL it does have is corrupt, and it can't replace that with a good copy because the command is failing, then what else is it going to do?

If the original WAL transfer got interrupted mid-stream, then you will have a bad record in the middle of the WAL.  If by some spectacular stroke of bad luck, the CRC checksum on that bad record happens to collide, then it will try to decode that bad record.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: endash not a graphic character?
Next
From: rob stone
Date:
Subject: Re: endash not a graphic character?