From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: "Hunley, Douglas" <douglas.hunley@openscg.com>,
        Tim Goodaire <tgoodaire@dyn.com>,
        pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: FSM corruption and standby servers
In-reply-to: 
 <CAKFQuwZkbH9r9bEp6X+9JjE8Q9mcXKDW0sjEJhAX3xBTa-jgGQ@mail.gmail.com>
References: 
 <CABP2sqKiPTUiXEoL1K2FD6dWwFpVNFHC_EhOzTca1miZkHaMsw@mail.gmail.com>
 <CAAD=pwHsr-wi1-pvPp3GzBP+f+X3f_KD2TcvMU9rqGqrE6Tt+w@mail.gmail.com>
 <20566.1477932936@sss.pgh.pa.us>
 <CAKFQuwZkbH9r9bEp6X+9JjE8Q9mcXKDW0sjEJhAX3xBTa-jgGQ@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Mon, 31 Oct 2016 10:27:44 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <23812.1477937964.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 31 Oct 2016 14:19:24 -0400
Message-ID: <23813.1477937964@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Mon, Oct 31, 2016 at 9:55 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I would have thought that the referenced page is clear enough about
>> needing to check the standbys; do you think it isn't?

> =E2=80=8BI can =E2=80=8Bsee how the following is a bit loose for someone =
not super-familiar
> with WAL.

Yeah.  On the other hand, I don't want people who aren't running
replication to stop reading as soon as they see something about standby
servers.  I tweaked the existing wording a bit to emphasize that standbys
can be corrupt even with a valid master; hopefully that's enough.

			regards, tom lane


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin