Re: Postgres has stopped logging

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx> 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


--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux