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

Re: Clean shutdown and warm standby

From: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-28 16:16:35
Message-ID: 1d4e0c10905280916l353300ebi5d7f1593779de070@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, May 28, 2009 at 6:06 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Thu, 2009-05-28 at 17:50 +0200, Guillaume Smet wrote:
>
>> I think it's a step forward, maybe not sufficient for you but I prefer
>> the situation now than before. It's safer because of the principle of
>> least surprise: I'm pretty sure a lot of people didn't even think that
>> the last WAL file was systematically missing.
>
> If I hadn't spoken out, I think you would have assumed you were safe and
> so would everybody else. Time is saved only if you perform the step
> manually - if time saving was your objective you should have been using
> a script in the first place. If you're using a script, carry on using
> it: nothing has changed, you still need to check.

You might think that but I won't have. I will still monitor my log
files carefully and check the last WAL file is received and treated on
the slave as I currently do.

I prefer checking it visually than using a script.

At least, now, I have a chance to have it working without a manual intervention.

> It's good you submitted a patch, I have no problem there, BTW, but
> applying a patch during beta, should either fix the problem or not be
> applied at all.

Well, I don't think we'll agree on that. Anyway, have a nice day :).

-- 
Guillaume

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-05-28 16:19:39
Subject: Re: PostgreSQL Developer meeting minutes up
Previous:From: Dmitry KoterovDate: 2009-05-28 16:16:18
Subject: Re: Fast ALTER TABLE ... ADD COLUMN ... DEFAULT xxx?

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