Re: Postgres has stopped logging

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