Re: Enabling archive_mode without restart

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: "Jonah H(dot) Harris" <jonah(dot)harris(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>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Enabling archive_mode without restart
Date: 2008-11-13 07:28:43
Message-ID: 1226561323.27904.396.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Wed, 2008-11-12 at 10:48 -0500, Jonah H. Harris wrote:
> > Anyway, I think this is worth fixing before release but it clearly isn't
> > worth attempting to rush a patch in the next few hours. I don't think
> > we'll find anyone who is happy with making it a restart-required option.
>
> I couldn't find a patch/commit for this and was just wondering whether
> someone is addressing it for 8.4? In a large-scale OLTP environment,
> uptime is paramount, and having to restart the database to enable PITR
> is a big PITA.

Agreed, though I think we should let the dust settle on other features
before working on this. We need to look at the full set of options we'll
need for replication and hot standby.

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2008-11-13 08:05:26 Re: SSL cleanups/hostname verification
Previous Message Dmitry Turin 2008-11-13 06:59:28 SQL5 budget