Postgres Pro
Downloads
Home   >   mailing lists

Re: FSM corruption and standby servers - Mailing list pgsql-admin

From Hunley, Douglas
Subject Re: FSM corruption and standby servers
Date
Msg-id CAAD=pwHsr-wi1-pvPp3GzBP+f+X3f_KD2TcvMU9rqGqrE6Tt+w@mail.gmail.com
Whole thread Raw
In response to FSM corruption and standby servers  (Tim Goodaire <tgoodaire@dyn.com>)
Responses Re: FSM corruption and standby servers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

On Mon, Oct 31, 2016 at 10:38 AM, Tim Goodaire <tgoodaire@dyn.com> wrote:
I have a question regarding the FSM corruption bug that is fixed in postgresql 9.5.5 (https://wiki.postgresql.org/wiki/Free_Space_Map_Problems). If I don't find any corruption on a master database, is it still possible that there is corruption on the standbys? 

It shouldn't be, iirc. FSMs are only ever created/updated by vacuum, which doesn't run on a slave until it is promoted to a master.


--
{
  "name" : "douglas j hunley",
  "email" : "douglas.hunley@openscg.com",
  "title" : "database engineer",
  "phone" : "+1 732 339 3419 x163"
}

pgsql-admin by date:

Previous
From: "Hunley, Douglas"
Date:
Subject: Re: WARNING: out of shared memory
Next
From: Tom Lane
Date:
Subject: Re: FSM corruption and standby servers