pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedI've got gaps in the log files?
4+ messages / 3 participants
[nested] [flat]
* I've got gaps in the log files?
@ 2012-03-06 16:03 Andreas <maps.on@gmx.net>
2012-03-06 17:38 ` Re: I've got gaps in the log files? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Andreas @ 2012-03-06 16:03 UTC (permalink / raw)
To: pgsql-admin
Hi,
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.
E.g. yesterday the last entry is at 09.54pm. Thats the change timestamp
of the file, too.
Today there is a new file whichs first line is 11.37am while I
definitely know there were users connected way earlier and there should
be comlaints about lost connections all the time as it is "normal" with
MS-Access as client via odbc.
Actually I was working at it yesterday after 10pm so there should be
log-lines for my DDL queries from that timespan.
OK, my issue might sound weired but I'd rather like to know where this
log stuff could have gotten lost.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I've got gaps in the log files?
2012-03-06 16:03 I've got gaps in the log files? Andreas <maps.on@gmx.net>
@ 2012-03-06 17:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-03-07 00:12 ` Re: I've got gaps in the log files? Andreas <maps.on@gmx.net>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2012-03-06 17:38 UTC (permalink / raw)
To: Andreas <maps.on@gmx.net>; +Cc: pgsql-admin
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.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I've got gaps in the log files?
2012-03-06 16:03 I've got gaps in the log files? Andreas <maps.on@gmx.net>
2012-03-06 17:38 ` Re: I've got gaps in the log files? Tom Lane <tgl@sss.pgh.pa.us>
@ 2012-03-07 00:12 ` Andreas <maps.on@gmx.net>
2012-03-07 03:42 ` Re: I've got gaps in the log files? Greg Sabino Mullane <greg@turnstep.com>
0 siblings, 1 reply; 4+ messages in thread
From: Andreas @ 2012-03-07 00:12 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: I've got gaps in the log files?
2012-03-06 16:03 I've got gaps in the log files? Andreas <maps.on@gmx.net>
2012-03-06 17:38 ` Re: I've got gaps in the log files? Tom Lane <tgl@sss.pgh.pa.us>
2012-03-07 00:12 ` Re: I've got gaps in the log files? Andreas <maps.on@gmx.net>
@ 2012-03-07 03:42 ` Greg Sabino Mullane <greg@turnstep.com>
0 siblings, 0 replies; 4+ messages in thread
From: Greg Sabino Mullane @ 2012-03-07 03:42 UTC (permalink / raw)
To: pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> I left them on defaults.
> Actually they are even commented out.
Never assume that the commented out version == default == actual value.
Always explicitly set parameters you care about.
- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201203062241
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAk9W2QMACgkQvJuQZxSWSsg8/wCgsw4+Z0WQw4WudPOOdveh9twR
WxgAnjMfVtXsGSF7TxbOI7vTDR6vuH7m
=eMNV
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-03-07 03:42 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-03-06 16:03 I've got gaps in the log files? Andreas <maps.on@gmx.net>
2012-03-06 17:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-03-07 00:12 ` Andreas <maps.on@gmx.net>
2012-03-07 03:42 ` Greg Sabino Mullane <greg@turnstep.com>
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