From: Christian Ullrich <chris@chrullrich.net>
To: pgsql-admin@postgresql.org
Subject: Re: WTF? 9.2.4 Logs have the wrong day of the week?
Date: Fri, 16 Aug 2013 15:55:53 +0200
Message-ID: <kulb12$q8i$1@ger.gmane.org> (raw)
In-Reply-To: <17178140.289068.1376440034511.JavaMail.root@mail.int.journyx.com>
References: <15287690.289056.1376439877258.JavaMail.root@mail.int.journyx.com>
<17178140.289068.1376440034511.JavaMail.root@mail.int.journyx.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
* Scott Whitney wrote:
> Everything you need to see is right here:
>
> [root@<serverNameRemoved> pg_log]# ls -lrt
> total 5924
> -rw------- 1 postgres postgres 708669 Aug 8 18:59 postgresql-Thu.log
> -rw------- 1 postgres postgres 669505 Aug 9 18:59 postgresql-Fri.log
> -rw------- 1 postgres postgres 666603 Aug 10 18:56 postgresql-Sat.log
> -rw------- 1 postgres postgres 559716 Aug 11 18:59 postgresql-Sun.log
> -rw------- 1 postgres postgres 626143 Aug 12 18:56 postgresql-Mon.log
> -rw------- 1 postgres postgres 2065282 Aug 13 18:24 postgresql-Tue.log
> -rw------- 1 postgres postgres 755099 Aug 13 19:22 postgresql-Wed.log
>
> [root@<serverNameRemoved> pg_log]# date
> Tue Aug 13 19:23:53 CDT 2013
log_timezone is set to UTC, which is normally six hours ahead of
Chicago, but does not observe DST, so currently it is five hours ahead.
18:24 plus five is still the same day, 19:22 plus five is the next day.
Quoting the docs:
log_timezone (string)
Sets the time zone used for timestamps written in the server log. Unlike
TimeZone, this value is cluster-wide, so that all sessions will report
timestamps consistently. The built-in default is GMT, but that is
typically overridden in postgresql.conf; initdb will install a setting
there corresponding to its system environment.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: chris@chrullrich.net
Subject: Re: WTF? 9.2.4 Logs have the wrong day of the week?
In-Reply-To: <kulb12$q8i$1@ger.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox