Re: Postgres has stopped logging

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lewis Kapell <lkapell(at)setonhome(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres has stopped logging
Date: 2009-06-05 16:02:40
Message-ID: 5287.1244217760@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Lewis Kapell <lkapell(at)setonhome(dot)org> writes:
> This is a really strange one. We are running PostgreSQL 8.3.7 on a
> Fedora Core 8 system (uname -a gives: 2.6.23.1-42.fc8).

> On Wednesday I was reading about the upcoming change in the default
> value of default_statistics_target from 10 to 100 - we had never changed
> this value, so I bumped it up a bit and also changed the value of
> log_autovacuum_min_duration so that I could monitor the results.
> Yesterday I tweaked the settings a bit more and continued to monitor the
> logs. About two hours later, the log file stopped growing.

Are you watching the right log file? I believe most Fedora packagings
of PG are set up to rotate log output among multiple files. In any
case it's hard to diagnose this without knowing what logging settings
you're using.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lewis Kapell 2009-06-05 16:13:58 Re: Postgres has stopped logging
Previous Message Lewis Kapell 2009-06-05 16:01:45 Re: Postgres has stopped logging