From: Tom Lane <tgl@sss.pgh.pa.us>
To: Deron <fecastle@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Timezone from PG8 to PG9
Date: Fri, 20 Dec 2013 19:11:01 -0500
Message-ID: <25616.1387584661@sss.pgh.pa.us> (raw)
In-Reply-To: <CAF3Lvs6hp=fN4Bx9vpeLvA=cgqJo3iNB4kETiD9inkRkkY0mhw@mail.gmail.com>
References: <CAF3Lvs6hp=fN4Bx9vpeLvA=cgqJo3iNB4kETiD9inkRkkY0mhw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Deron <fecastle@gmail.com> writes:
> Hello we were upgrading a test system from PG8.3.6 to PG 9.3 and it appears
> as though the timezone is not set on the new PG9.3. I should say that we
> never did set the timezone for PG8, but somehow the PG server knew the
> 'localtime' of the system:
> show timezone;
> TimeZone
> ------------
> US/Eastern
> (1 row)
> However, after upgrading to PG9:
> show timezone;
> TimeZone
> ----------
> GMT
> (1 row)
> We saw the same for US/Pacific zone as well.
> We do set /etc/localtime for the local timezone of the box. We can
> configure this in the postgresql.conf file. It does appear as though PG9
> server reads /etc/localtime on startup, but it is not set.
IIRC, we moved the determination of the default timezone into initdb
somewhere along the line; so what matters now is the system environment
initdb saw, not what the server sees on start. If you don't like what
you're getting, change it in postgresql.conf.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, fecastle@gmail.com
Subject: Re: Timezone from PG8 to PG9
In-Reply-To: <25616.1387584661@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox