Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id B60BA171224F for ; Tue, 6 Mar 2012 20:12:26 -0400 (AST) Received: from mailout-de.gmx.net ([213.165.64.23]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1S54US-00019L-Di for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 00:12:25 +0000 Received: (qmail invoked by alias); 07 Mar 2012 00:12:11 -0000 Received: from p57BB65D8.dip.t-dialin.net (EHLO [192.168.1.20]) [87.187.101.216] by mail.gmx.net (mp033) with SMTP; 07 Mar 2012 01:12:11 +0100 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX1982MdWtql82CpwEj7tK6G1/QIEpeRo4VcVC7vuKk MZkZVLkGcN8aB7 Message-ID: <4F56A7DB.2030905@gmx.net> Date: Wed, 07 Mar 2012 01:12:11 +0100 From: Andreas User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: I've got gaps in the log files? References: <4F563544.9040700@gmx.net> <1797.1331055529@sss.pgh.pa.us> In-Reply-To: <1797.1331055529@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/19 X-Sequence-Number: 39207 Am 06.03.2012 18:38, schrieb Tom Lane: > Andreas writes: >> it appeares I've got gaps in the log files. >> It's a PG 9.1 from the OpenSuse 12.1 distribution. >> I know the server is running so it should dump it's feelings all the >> time in those files in PGDATA/pg_log. >> But I find huge gaps where nothing is written. > The only suggestion that comes to mind offhand is to check the logfile > rotation parameters in postgresql.conf. Maybe the missing log entries > went to a file that got truncated and rewritten afterwards because of > poorly selected rotation parameters. > > I left them on defaults. Actually they are even commented out. #log_truncate_on_rotation = off #log_rotation_age = 1d #log_rotation_size = 10MB It's not as if I expect particularily huge log files anyway. On most days its just the one that got created when the rotation starts a new one like postgresql-2012-03-07_000000.log regards Andreas