Re: Time-Delayed Standbys - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Time-Delayed Standbys
Date
Msg-id 3398.1386859959@sss.pgh.pa.us
Whole thread Raw
In response to Re: Time-Delayed Standbys  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Time-Delayed Standbys
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On 12 December 2013 11:05, Andres Freund <andres@2ndquadrant.com> wrote:
>>> My suggestion would be to add the TZ to the checkpoint record. This
>>> way all users of WAL can see the TZ of the master and act accordingly.
>>> I'll do a separate patch for that.

>> Intuitively I'd say that might be useful - but I am not reall sure what
>> for. And we don't exactly have a great interface for looking at a
>> checkpoint's data. Maybe add it to the control file instead?

> That's actually what I had in mind, I just phrased it badly in mid-thought.

I don't think you realize what a can of worms that would be.  There's
no compact representation of "a timezone", unless you are only proposing
to store the UTC offset; and frankly I'm not particularly seeing the point
of that.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Reference to parent query from ANY sublink
Next
From: Robert Haas
Date:
Subject: Re: Changeset Extraction Interfaces