Re: pg_log is 2 hours ahead ???

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_log is 2 hours ahead ???
Date: 2012-05-23 23:17:33
Message-ID: 4FBD700D.7020508@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/23/2012 04:11 PM, Andreas wrote:
> Hi,
>
> I'm running a PG 9.1.3 on OpenSuse 12.1.
> I found that pg_log is 2 hours ahead though date on the console
> shows the right date and time.
> I have the ntp daemon watching the system's time every 60 minutes so
> this shouldn't be an issue.
>
> The time in PG's logfiles filenames as well as the timestamps within
> the logs are 2 hours ahead.
>
> How can I fix this?
>
show log_timezone;

If not what you want, update it in postgresql.conf

Cheers,
Steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-05-23 23:25:58 Re: FATAL: lock file "postmaster.pid" already exists
Previous Message Andreas 2012-05-23 23:11:48 pg_log is 2 hours ahead ???