On 09/24/2015 07:01 AM, Willy-Bas Loos wrote:
> =# show timezone;
> TimeZone
> -----------
> localtime
> (1 row)
>
>
This sounded familiar:
http://www.postgresql.org/message-id/m3616t3m5d.fsf@carbon.jhcloos.org
From there, per Tom Lane:
select * from pg_settings where name = 'TimeZone';
This will show what is actually supplying the timezone value from the
Postgres side.
Might be easiest to just set timezone in postgresql.conf to what you
want it to be.
--
Adrian Klaver
adrian.klaver@aklaver.com