Re: Postgres has stopped logging - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgres has stopped logging
Date
Msg-id 5287.1244217760@sss.pgh.pa.us
Whole thread Raw
In response to Postgres has stopped logging  (Lewis Kapell <lkapell@setonhome.org>)
Responses Re: Postgres has stopped logging  (Lewis Kapell <lkapell@setonhome.org>)
List pgsql-admin
Lewis Kapell <lkapell@setonhome.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

pgsql-admin by date:

Previous
From: Lewis Kapell
Date:
Subject: Re: Postgres has stopped logging
Next
From: Lewis Kapell
Date:
Subject: Re: Postgres has stopped logging