From: Andreas <maps.on@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: I've got gaps in the log files?
Date: Wed, 07 Mar 2012 01:12:11 +0100
Message-ID: <4F56A7DB.2030905@gmx.net> (raw)
In-Reply-To: <1797.1331055529@sss.pgh.pa.us>
References: <4F563544.9040700@gmx.net>
<1797.1331055529@sss.pgh.pa.us>
Am 06.03.2012 18:38, schrieb Tom Lane:
> Andreas<maps.on@gmx.net> 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
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: maps.on@gmx.net, tgl@sss.pgh.pa.us
Subject: Re: I've got gaps in the log files?
In-Reply-To: <4F56A7DB.2030905@gmx.net>
* 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