From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Deron <fecastle(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Timezone from PG8 to PG9 |
Date: | 2013-12-21 00:11:01 |
Message-ID: | 25616.1387584661@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Deron <fecastle(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Williams | 2013-12-23 15:19:03 | pg_restore >10million large objects |
Previous Message | Deron | 2013-12-20 22:29:13 | Timezone from PG8 to PG9 |