Skip site navigation (1) Skip section navigation (2)

Re: Clean shutdown and warm standby

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>, Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Clean shutdown and warm standby
Date: 2009-05-29 20:37:47
Message-ID: 1243629467.31613.97.camel@ebony.2ndQuadrant (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, 2009-05-29 at 14:54 -0400, Robert Haas wrote:
> On Fri, May 29, 2009 at 2:23 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> > Regrettably, the patch doesn't remove the problem it was supposed to
> > remove and I'm highlighting there is still risk of data loss. I suggest
> > that we don't change any docs, and carefully word or even avoid any
> > release note inclusion to avoid lulling people into stopping safety
> > measures.
> 
> I think it's pretty clear that you and the OP are talking about two
> different problems.  To quote Guillaume:
> 
> "Yes, the problem is that before this change, even with a working
> replication and a clean shutdown, you still had to replicate the last
> WAL file by hand."
> 
> I think that's a pretty legitimate complaint.  

It's valid complaint, yes, but only for people that do this manually,
which is nobody I ever met, in *production*. (ymmv etc)

> You seem to think that this wasn't worth fixing...

And for them, it hasn't been completely fixed. That point was not made
by patch author or committer, leaving the impression it was now
completely safe, which, I truly regret to say, is not correct.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-05-29 20:49:32
Subject: Re: search_path vs extensions
Previous:From: Simon RiggsDate: 2009-05-29 19:45:31
Subject: Re: Clean shutdown and warm standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group