From scott@journyx.com Wed Aug 14 00:27:28 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9Ovw-0007gq-Nl for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 00:27:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V9Ovw-00023h-5o for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 00:27:28 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9Ovv-00023M-0h for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 00:27:27 +0000 Received: from mail.journyx.com ([209.163.206.41] helo=mail.int.journyx.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9Ovq-000069-1D for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 00:27:25 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id E055A7E64AA for ; Tue, 13 Aug 2013 19:27:20 -0500 (CDT) X-Virus-Scanned: amavisd-new at zimbra.int.journyx.com Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 8TExlhCpS12l for ; Tue, 13 Aug 2013 19:27:14 -0500 (CDT) Received: from mail.int.journyx.com (zimbra.int.journyx.com [192.168.100.5]) by mail.int.journyx.com (Postfix) with ESMTP id 9B47A7E64AF for ; Tue, 13 Aug 2013 19:27:14 -0500 (CDT) Date: Tue, 13 Aug 2013 19:27:14 -0500 (CDT) From: Scott Whitney Reply-To: Scott Whitney To: pgsql-admin@postgresql.org Message-ID: <17178140.289068.1376440034511.JavaMail.root@mail.int.journyx.com> In-Reply-To: <15287690.289056.1376439877258.JavaMail.root@mail.int.journyx.com> Subject: WTF? 9.2.4 Logs have the wrong day of the week? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_289067_19318728.1376440034508" X-Originating-IP: [192.168.100.188] X-Mailer: Zimbra 7.2.4_GA_2900 (ZimbraWebClient - GC28 (Win)/7.2.4_GA_2900) X-Pg-Spam-Score: -2.0 (--) 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 ------=_Part_289067_19318728.1376440034508 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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 so...yah..anyone? For further information, please see: http://www.dayoftheweek.org/?m=August&d=13&y=2013&go=Go It's the "Wed" part that is confusing me... ------=_Part_289067_19318728.1376440034508 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: times new roman,new york,times,serif; font-size: = 12pt; color: #000000'>Everything you need to see is right here:

[root@<serverNameRemoved> pg_log]# ls -lrt
total 592= 4
-rw------- 1 postgres postgres  708669 Aug &nbs= p;8 18:59 postgresql-Thu.log
-rw------- 1 postgres postgres  = ;669505 Aug  9 18:59 postgresql-Fri.log
-rw------- 1 postgre= s 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.l= og
-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@<serverNam= eRemoved> pg_log]# date
Tue Aug 13 19:23:53 CDT 2013

so...yah..anyone?

For furthe= r information, please see:

=
It's the "Wed" part that is confusing me...

= ------=_Part_289067_19318728.1376440034508-- From netllama@gmail.com Wed Aug 14 00:30:27 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9Oyo-0007qH-Os for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 00:30:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V9Oyo-0003wD-9I for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 00:30:26 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9Oyn-0003w5-Dg for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 00:30:25 +0000 Received: from mail-vb0-x234.google.com ([2607:f8b0:400c:c02::234]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9Oyg-00007a-4V for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 00:30:24 +0000 Received: by mail-vb0-f52.google.com with SMTP id f12so7092332vbg.25 for ; Tue, 13 Aug 2013 17:30:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=7AXHuuSbvoGisQc+g5FMloZmuMgKKsP3ftBEnwwiU7M=; b=Y1NrcxUg1TtIswouGubJ1be+xOpMnbKzHsuYfFs4ZJj16MVDTr9zGQeBBP63MQKb1y 4yA/2jL8SfLfFrv5ZY+qiXETmKws09gAuf3KylKpx+OzO4dxOrufTKIaQtFDFUyO1wPW bAomvn/ofz2EUQ5G1uKsmVl/u4nQIaP9XVI8l5q3/V/q8jQYv3edTP6yYYXYbRNsaruP wq+SmgeuYFr2v2Fszwqq2x0BjbNeGZZs0sQV5zUapmnas84tw9HDpZkUMGrpKC3xLw+M SJcvyqhQGi2ajcDpuyohobDxf+pAFcg/C2poz76sO+QnaIp5ZeW53iIkOMgKgeAgN6GA 3Jog== MIME-Version: 1.0 X-Received: by 10.58.201.69 with SMTP id jy5mr4200234vec.29.1376440217473; Tue, 13 Aug 2013 17:30:17 -0700 (PDT) Received: by 10.220.249.134 with HTTP; Tue, 13 Aug 2013 17:30:17 -0700 (PDT) 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> Date: Tue, 13 Aug 2013 17:30:17 -0700 Message-ID: Subject: Re: WTF? 9.2.4 Logs have the wrong day of the week? From: Lonni J Friedman To: Scott Whitney Cc: "pgsql-admin@postgresql.org" Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -0.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 GMT offset? On Tue, Aug 13, 2013 at 5:27 PM, 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 > > so...yah..anyone? > > For further information, please see: > http://www.dayoftheweek.org/?m=August&d=13&y=2013&go=Go > > It's the "Wed" part that is confusing me... > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand https://netllama.linux-sxs.org -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin From tgl@sss.pgh.pa.us Wed Aug 14 00:54:01 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9PLc-0000OI-GC for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 00:54:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V9PLb-0003LH-8g for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 00:53:59 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9PLa-0003L6-4h for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 00:53:58 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9PLX-0000a0-Fv for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 00:53:57 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id r7E0rg6t017745; Tue, 13 Aug 2013 20:53:42 -0400 From: Tom Lane To: Scott Whitney , Scott Whitney cc: pgsql-admin@postgresql.org Subject: Re: WTF? 9.2.4 Logs have the wrong day of the week? In-reply-to: <17178140.289068.1376440034511.JavaMail.root@mail.int.journyx.com> References: <17178140.289068.1376440034511.JavaMail.root@mail.int.journyx.com> Comments: In-reply-to Scott Whitney message dated "Tue, 13 Aug 2013 19:27:14 -0500" Date: Tue, 13 Aug 2013 20:53:42 -0400 Message-ID: <17744.1376441622@sss.pgh.pa.us> X-Pg-Spam-Score: -2.0 (--) 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 writes: > Everything you need to see is right here: Uh, everything except the log_timezone setting. I believe log files will be named according to the local time in the log_timezone at the instant they're created. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin From scott@journyx.com Wed Aug 14 01:04:06 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9PVO-0000qT-2a for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 01:04:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V9PVN-0007lX-GG for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 01:04:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9PVM-0007lQ-D4 for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 01:04:04 +0000 Received: from mail.journyx.com ([209.163.206.41] helo=mail.int.journyx.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9PVI-0007sp-H3 for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 01:04:04 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id 719967E64D8; Tue, 13 Aug 2013 20:03:58 -0500 (CDT) X-Virus-Scanned: amavisd-new at zimbra.int.journyx.com Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HncYv+FNqS8s; Tue, 13 Aug 2013 20:03:54 -0500 (CDT) Received: from mail.int.journyx.com (zimbra.int.journyx.com [192.168.100.5]) by mail.int.journyx.com (Postfix) with ESMTP id B5CA17E64BA; Tue, 13 Aug 2013 20:03:54 -0500 (CDT) Date: Tue, 13 Aug 2013 20:03:54 -0500 (CDT) Subject: Re: WTF? 9.2.4 Logs have the wrong day of the week? Message-ID: Importance: normal To: Tom Lane , Scott Whitney Cc: pgsql-admin@postgresql.org Reply-To: scott MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--_com.android.email_2293576239827250" X-Mailer: Zimbra 7.2.4_GA_2900 (MobileSync - SAMSUNG-SGH-I777/100.40102) From: Scott Whitney X-Pg-Spam-Score: -4.7 (----) 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 ----_com.android.email_2293576239827250 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 U2VydmVyIGlzIHNldCB0byAiQ2hpY2Fnby4iIENEVCAob3IgQ1NULi4uYXJlIHdlIGluIG9yIG91 dD8gSSBuZXZlciByZW1lbWJlci4uLikgR01UIC02LzUuwqAKCi0tLS0tLS0tIE9yaWdpbmFsIG1l c3NhZ2UgLS0tLS0tLS0KRnJvbTogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPiAKRGF0ZTog MDgvMTMvMjAxMyAgNzo1NCBQTSAgKEdNVC0wNjowMCkgClRvOiBTY290dCBXaGl0bmV5IDxzd2hp dG5leUBqb3Vybnl4LmNvbT4sU2NvdHQgV2hpdG5leSA8c2NvdHRAam91cm55eC5jb20+IApDYzog cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcgClN1YmplY3Q6IFJlOiBbQURNSU5dIFdURj8gOS4y LjQgTG9ncyBoYXZlIHRoZSB3cm9uZyBkYXkgb2YgdGhlIHdlZWs/IAogClNjb3R0IFdoaXRuZXkg PHNjb3R0QGpvdXJueXguY29tPiB3cml0ZXM6Cj4gRXZlcnl0aGluZyB5b3UgbmVlZCB0byBzZWUg aXMgcmlnaHQgaGVyZTogCgpVaCwgZXZlcnl0aGluZyBleGNlcHQgdGhlIGxvZ190aW1lem9uZSBz ZXR0aW5nLsKgIEkgYmVsaWV2ZSBsb2cgZmlsZXMgd2lsbApiZSBuYW1lZCBhY2NvcmRpbmcgdG8g dGhlIGxvY2FsIHRpbWUgaW4gdGhlIGxvZ190aW1lem9uZSBhdCB0aGUgaW5zdGFudAp0aGV5J3Jl IGNyZWF0ZWQuCgpyZWdhcmRzLCB0b20gbGFuZQo= ----_com.android.email_2293576239827250 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9VVRGLTgiPjwvaGVhZD48Ym9keSA+U2VydmVyIGlzIHNldCB0byAiQ2hp Y2Fnby4iIENEVCAob3IgQ1NULi4uYXJlIHdlIGluIG9yIG91dD8gSSBuZXZlciByZW1lbWJlci4u LikgR01UIC02LzUuJm5ic3A7PGJyPjxicj48YnI+LS0tLS0tLS0gT3JpZ2luYWwgbWVzc2FnZSAt LS0tLS0tLTxicj5Gcm9tOiBUb20gTGFuZSAmbHQ7dGdsQHNzcy5wZ2gucGEudXMmZ3Q7IDxicj5E YXRlOiAwOC8xMy8yMDEzICA3OjU0IFBNICAoR01ULTA2OjAwKSA8YnI+VG86IFNjb3R0IFdoaXRu ZXkgJmx0O3N3aGl0bmV5QGpvdXJueXguY29tJmd0OyxTY290dCBXaGl0bmV5ICZsdDtzY290dEBq b3Vybnl4LmNvbSZndDsgPGJyPkNjOiBwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZyA8YnI+U3Vi amVjdDogUmU6IFtBRE1JTl0gV1RGPyA5LjIuNCBMb2dzIGhhdmUgdGhlIHdyb25nIGRheSBvZiB0 aGUgd2Vlaz8gPGJyPiA8YnI+PGJyPlNjb3R0IFdoaXRuZXkgJmx0O3Njb3R0QGpvdXJueXguY29t Jmd0OyB3cml0ZXM6PGJyPiZndDsgRXZlcnl0aGluZyB5b3UgbmVlZCB0byBzZWUgaXMgcmlnaHQg aGVyZTogPGJyPjxicj5VaCwgZXZlcnl0aGluZyBleGNlcHQgdGhlIGxvZ190aW1lem9uZSBzZXR0 aW5nLiZuYnNwOyBJIGJlbGlldmUgbG9nIGZpbGVzIHdpbGw8YnI+YmUgbmFtZWQgYWNjb3JkaW5n IHRvIHRoZSBsb2NhbCB0aW1lIGluIHRoZSBsb2dfdGltZXpvbmUgYXQgdGhlIGluc3RhbnQ8YnI+ dGhleSdyZSBjcmVhdGVkLjxicj48YnI+CQkJcmVnYXJkcywgdG9tIGxhbmU8YnI+PC9ib2R5Pg== ----_com.android.email_2293576239827250-- From emorrasg@yahoo.es Wed Aug 14 13:50:37 2013 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9bTB-0006Fl-7s for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 13:50:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V9bTA-0003qL-Na for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2013 13:50:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V9bT8-0003qC-5s for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 13:50:34 +0000 Received: from nm2-vm1.bullet.mail.ird.yahoo.com ([77.238.189.200]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V9bT3-0004au-QP for pgsql-admin@postgresql.org; Wed, 14 Aug 2013 13:50:33 +0000 Received: from [77.238.189.55] by nm2.bullet.mail.ird.yahoo.com with NNFMP; 14 Aug 2013 13:50:26 -0000 Received: from [46.228.39.71] by tm8.bullet.mail.ird.yahoo.com with NNFMP; 14 Aug 2013 13:50:26 -0000 Received: from [127.0.0.1] by smtp108.mail.ir2.yahoo.com with NNFMP; 14 Aug 2013 13:50:26 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s1024; t=1376488226; bh=1Xy66oLfjAfGtsTzvF5607rSDTzk4hd46iXHOyZz900=; h=X-Yahoo-Newman-Id:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:X-Rocket-Received:Date:From:To:Cc:Subject:Message-Id:In-Reply-To:References:X-Mailer:Disposition-Notification-To:Mime-Version:Content-Type:Content-Transfer-Encoding; b=TBqfw+2LZRWCHmTP6Ie/l/BIiZ8s42JRFX/UJBCVVEsi5tCOZpxwj0rnoJ7kgPqKXxr6cVquwc9+epc5aZdWY6LvD9h3J8NF5ne1dfKFSg1SKN1KNQ/X2EThC1V/WyNBHI7Ujb9aN6YbrJ8eKBbs6gtt2w0JAIWf8PG57/rXDBc= X-Yahoo-Newman-Id: 73650.39501.bm@smtp108.mail.ir2.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: pOekKJIVM1lUQAnzTzJxbYIKsMIa5opViJ7SKdFDqAnEiJh x7CYvjFm1OPZ6sKlnkC7X7bGxj_pFaPPVBrj9gMWrCt3MxHtLkHf0RKfwYXT zPbHlCH7EbpCxD0141B9S8dn6EJBLN.nvyfd1xbzGJV1K8sqI8E8YNM7De3l EmgRUZbX3QpHMx7Tqag8t0YFPOsUKXGoYyFvqpdUXNV3gDIhy12VPoe5jyRp ibfKi.yoErV.LyJV4A4ilrIclW34AYMSY4IdfcKf0ACRGFxJUED6YlyoTp5Y PV0RkKLKyWJ5C4BzlEmYTqjuXGrlRiaRV8XUYwGB7nrjjFT5QFqyRTYCrTBE sm.Lun5ZI7XxtZgBs1DNWPvwhok5GhEyBhSNYdInaJbS9u7U.4q4g3nTSZk1 JqOIZhaC._z5AYbqOjtCa2DxAbD2yqqx8WJCM6YZwmo0usE7tKipMeTzNt0a aDY._2uD484D5twWsXj9GFmNLiy0GAjiEaZx.snQ6m7g9zSXa2nHKBYuXTE7 PcBr7q89wW1b2Zv8QhYGsifx1UUlhsLaKbKEtTYeZkNJUFhFqHLHvKJwg3xo j__85Lnslz3IXKo3zMOtnjftdqO.HiLgzGDW2aEj6oVyk4g-- X-Yahoo-SMTP: mX392iiswBAeJNdO_s.EW62LZDJR X-Rocket-Received: from camibar.emorras.eu (emorrasg@89.7.216.154 with ) by smtp108.mail.ir2.yahoo.com with SMTP; 14 Aug 2013 13:50:26 +0000 UTC Date: Wed, 14 Aug 2013 15:50:24 +0200 From: Eduardo Morras To: pgsql-admin@postgresql.org Cc: Scott Whitney Subject: Re: WTF? 9.2.4 Logs have the wrong day of the week? Message-Id: <20130814155024.3fbe1f05479363b81f15c8fb@yahoo.es> 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> X-Mailer: Sylpheed 3.3.0 (GTK+ 2.24.19; amd64-portbld-freebsd9.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.0 (--) 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 On Tue, 13 Aug 2013 19:27:14 -0500 (CDT) 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 > > > so...yah..anyone? > Did you set a max log of 2MB = 2097152 bytes ? Also, up to day 12, all logs roll at 19:00, perhaps to avoid the name collision with the second log file of day 13, it was saved as next available log name. > > For further information, please see: > http://www.dayoftheweek.org/?m=August&d=13&y=2013&go=Go > > > It's the "Wed" part that is confusing me... > --- --- Eduardo Morras -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin From chris@chrullrich.net Fri Aug 16 13:56:11 2013 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