Re: Postgres has stopped logging

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

If I search the output of ps -ax for entries containing both "postgres:"
and "process" I get the following:

2259 ? Ss 0:03 postgres: logger process
2261 ? Ss 0:29 postgres: writer process
2262 ? Ss 0:17 postgres: wal writer process
2263 ? Ss 0:10 postgres: autovacuum launcher process
2264 ? Ss 4:51 postgres: stats collector process

thanks
Lewis Kapell

Tom Lane wrote:
> Lewis Kapell <lkapell(at)setonhome(dot)org> writes:
>> 2) The relevant section of the config file looks like this:
>
>> #log_destination = 'stderr'
>> logging_collector = on
>> log_directory = '/var/log/postgres'
>> log_filename = 'postgresql-%Y-%m-%d.log'
>> #log_truncate_on_rotation = off
>> log_rotation_age = 7d
>> #log_rotation_size = 10MB
>
> Those look reasonably sane. Have you checked that the logger
> subprocess is still running? The postmaster is supposed to restart
> it if it dies, but I wouldn't be astonished if something went wrong
> in that ...
>
> regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-06-05 16:56:51 Re: Postgres has stopped logging
Previous Message Tom Lane 2009-06-05 16:23:56 Re: Postgres has stopped logging