| From: | "Leonardo M(dot) Ramé" <l(dot)rame(at)griensu(dot)com> |
|---|---|
| To: | PostgreSql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Timezone mismatch |
| Date: | 2015-03-20 15:43:57 |
| Message-ID: | 550C403D.7050409@griensu.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El 20/03/15 a las 12:38, Steve Crawford escibió:
> On 03/20/2015 08:29 AM, "Leonardo M. Ramé" wrote:
>> Hi, I had to change the O.S. timezone and aparently PostgreSql
>> continues using the old timezone, how can I force update it's time
>> zone?.
>>
>> Using PostgreSql 8.4 on Ubuntu Server 12.04.
>>
>> To update the OS timezone I used sudo dpkg-reconfigure tzdata
>
> Did you reload/restart PostgreSQL after making the change?
>
> What is the setting of timezone in postgresql.conf?
>
> What is set as the timezone on the *client* side? (That's really more
> relevant for timestamp_tz data.)
>
> Cheers,
> Steve
>
>
>
Hi Steve, I did a "select pg_reload_conf();" from psql. Is this enough?.
In postgresql.conf I have timezone and timezone_abbreviations commented,
as default.
From client side I never set any timezone related parameter.
Leonardo.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-03-20 16:03:16 | Re: Timezone mismatch |
| Previous Message | Steve Crawford | 2015-03-20 15:38:56 | Re: Timezone mismatch |