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

Re: pg_retainxlog for inclusion in 9.3?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_retainxlog for inclusion in 9.3?
Date: 2013-01-15 18:54:33
Message-ID: CA+TgmoagodFngSt6A3sG3wPp5zfC-ZAnvMa-c6EXk1uHnVt5fw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Jan 15, 2013 at 2:51 AM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Mon, Jan 14, 2013 at 5:56 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> On Fri, Jan 4, 2013 at 4:55 PM, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr> wrote:
>>> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>>>> Mostly that it seems like a hack, and I suspect we may come up with a
>>>> better way to do this in the future.
>>>
>>> Do you have the specs of such better way? Would it be a problem to have
>>> both pg_retainxlog and the new way?
>>
>> Well, I think in the long term we are likely to want the master to
>> have some kind of ability to track the positions of its slaves, even
>> when they are disconnected.  And, optionally, to retain the WAL that
>> they need, again even when they are disconnected.  If such an ability
>> materializes, this will be moot (even as I think that pg_standby is
>> now largely moot, at least for new installations, now that we have
>> standby_mode=on).
>
> I agree. But just as we had pg_standby for quite a while before we got
> standby_mode=on, I believe we should have pg_retainxlog (or something
> like it) until we have something more integrated.

Yep, not disagreeing.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2013-01-15 18:58:00
Subject: Re: unlogged tables vs. GIST
Previous:From: Robert HaasDate: 2013-01-15 18:53:15
Subject: Re: unlogged tables vs. GIST

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