Re: Timezone mismatch

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: "Leonardo M(dot) Ramé" <l(dot)rame(at)griensu(dot)com>, PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Timezone mismatch
Date: 2015-03-20 15:38:56
Message-ID: 550C3F10.6080201@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leonardo M. Ramé 2015-03-20 15:43:57 Re: Timezone mismatch
Previous Message Leonardo M. Ramé 2015-03-20 15:29:09 Timezone mismatch