Postgres Pro
Downloads
Home   >   mailing lists

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

From Simon Riggs
Subject Re: Critical failure of standby
Date
Msg-id CANP8+jK+jXcoAV-d2_Y7iAP4nXSvb93HkQV8GDUfrxCR6cg+5A@mail.gmail.com
Whole thread Raw
In response to Re: Critical failure of standby  (James Sewell <james.sewell@jirotech.com>)
Responses Re: Critical failure of standby  (James Sewell <james.sewell@jirotech.com>)
List pgsql-general
Tree view
On 16 August 2016 at 08:11, James Sewell <james.sewell@jirotech.com> wrote:
 
As per the logs there was a crash of one standby, which seems to have corrupted that standby and the two cascading standby.
  • No backups
  • Full page writes enabled
  • Fsync enabled
WAL records are CRC checked, so it may just be a bug, not corruption that affects multiple servers.

At the moment we know the Startup process died, but we don't know why.

Do you repeatedly get this error?

Please set log_error_verbosity = VERBOSE and rerun

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: C++ port of Postgres
Next
From: Amitabh Kant
Date:
Subject: Re: Uber migrated from Postgres to MySQL