It is 'on'.
postgres=# show logging_collector;
logging_collector
-------------------
on
(1 row)
postgres=#
Maria
-----Original Message-----
From: Igor Neyman [mailto:ineyman@perceptron.com]
Sent: Thursday, March 12, 2015 11:52 AM
To: Rossi, Maria; 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
Cc: Postgres Maillist
Subject: RE: [ADMIN] Errorlog empty
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rossi, Maria
Sent: Thursday, March 12, 2015 11:29 AM
To: 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
Cc: Postgres Maillist
Subject: Re: [ADMIN] Errorlog empty
The logging_collector is on, but I don’t know if it was restarted after it was turned on. I did run a ‘pg_ctl reload’,
butstill it did not log any msgs.
Does it need an actual restart? I cannot simply do that because this is production, has to be scheduled.
Thanks.
Maria
After ‘pg_ctl reload’ you can check current value of any parameter (including logging_collector) by issuing:
Show <parameter_name>
i.e.: show logging_collector;
Regards,
Igor Neyman