Re: epoch and timezone changed bevior

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(dot)klaver(at)aklaver(dot)com