Re: Timezone information - Mailing list pgsql-general

From Tom Lane
Subject Re: Timezone information
Date
Msg-id 16435.1392848873@sss.pgh.pa.us
Whole thread Raw
In response to Re: Timezone information  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: Timezone information  (Dev Kumkar <devdas.kumkar@gmail.com>)
List pgsql-general
Dev Kumkar <devdas.kumkar@gmail.com> writes:
> On Thu, Feb 20, 2014 at 3:07 AM, Adrian Klaver <adrian.klaver@aklaver.com>wrote:
>> Do you know where the machine is going when you do the install?

> No if that was the case then target could have set before shipping itself.
> Machine TGT-Region is not known here.

The functionality of determining an IANA timezone name equivalent to the
platform's behavior is currently embedded in initdb and isn't separately
accessible.  So you've got several options:

1. Wait to do initdb until the machine is installed.

2. Modify the timezone setting in postgresql.conf after the machine is
installed (although there might not be an easy way to determine what
to set it to).

3. Leave the server timezone setting as GMT and rely on clients to select
the zone they want to work in.

            regards, tom lane


pgsql-general by date:

Previous
From: Terence Ferraro
Date:
Subject: Re: Timezone information
Next
From: Adrian Klaver
Date:
Subject: Re: Timezone information