Re: Problem with streaming replication, backups, and recovery (9.0.x)
Kevin Grittner <kevin.grittner@wicourts.gov>
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <depesz@depesz.com>
Cc: "Fujii Masao" <masao.fujii@gmail.com>, <pgsql-hackers@postgresql.org>
Date: 2011-03-29T13:49:03Z
Lists: pgsql-hackers
hubert depesz lubaczewski <depesz@depesz.com> wrote: > it worked. now the slave2 is working as stand alone. > > what does it tell us? will any work happening after checkpoint > break it anyway? I'm less sure about what will put it into a bad state again than I was that an immediate checkpoint would put you into a good state. I have a vague feeling that I've seen or heard something which suggests that doing this during a spread checkpoint might be a problem as things currently stand. I can't be more specific without digging through code, and I'm pretty swamped at the moment. -Kevin