Re: epoch and timezone changed bevior - Mailing list pgsql-general

From Adrian Klaver
Subject Re: epoch and timezone changed bevior
Date
Msg-id 56040B4B.5030206@aklaver.com
Whole thread Raw
In response to Re: epoch and timezone changed bevior  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: epoch and timezone changed bevior
List pgsql-general
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: epoch and timezone changed bevior
Next
From: Tom Lane
Date:
Subject: Re: epoch and timezone changed bevior