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

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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres has stopped logging
Next
From: Tom Lane
Date:
Subject: Re: Postgres has stopped logging