Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VAKVf-0003WE-91 for pgsql-admin@arkaria.postgresql.org; Fri, 16 Aug 2013 13:56:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VAKVe-0003ew-Ex for pgsql-admin@arkaria.postgresql.org; Fri, 16 Aug 2013 13:56:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VAKVd-0003eq-MG for pgsql-admin@postgresql.org; Fri, 16 Aug 2013 13:56:09 +0000 Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VAKVZ-0005pR-V3 for pgsql-admin@postgresql.org; Fri, 16 Aug 2013 13:56:09 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1VAKVX-0005Lz-Oq for pgsql-admin@postgresql.org; Fri, 16 Aug 2013 15:56:03 +0200 Received: from 217.31.70.82 ([217.31.70.82]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 16 Aug 2013 15:56:03 +0200 Received: from chris by 217.31.70.82 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 16 Aug 2013 15:56:03 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Christian Ullrich Subject: Re: WTF? 9.2.4 Logs have the wrong day of the week? Date: Fri, 16 Aug 2013 15:55:53 +0200 Lines: 34 Message-ID: References: <15287690.289056.1376439877258.JavaMail.root@mail.int.journyx.com> <17178140.289068.1376440034511.JavaMail.root@mail.int.journyx.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 217.31.70.82 User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130801 Thunderbird/17.0.8 In-Reply-To: <17178140.289068.1376440034511.JavaMail.root@mail.int.journyx.com> X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org * Scott Whitney wrote: > Everything you need to see is right here: > > [root@ 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@ 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