Re: I've got gaps in the log files?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: I've got gaps in the log files?
Date: 2012-03-07 00:12:11
Message-ID: 4F56A7DB.2030905@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am 06.03.2012 18:38, schrieb Tom Lane:
> Andreas<maps(dot)on(at)gmx(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Sabino Mullane 2012-03-07 03:42:22 Re: I've got gaps in the log files?
Previous Message Todd Hunt 2012-03-06 22:03:01 Looking for help on backing up a large database (500GB+) with LOBs