Re: Errorlog empty - Mailing list pgsql-admin

From Rossi, Maria
Subject Re: Errorlog empty
Date
Msg-id 33A4D5087BF0D44DA69C5EEF666BC1D742535EE4@usprmbp01c
Whole thread Raw
In response to Re: Errorlog empty  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: Errorlog empty
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Igor Neyman
Date:
Subject: Re: Errorlog empty
Next
From: Jiří Hlinka
Date:
Subject: pg_repack 1.3.1 RPM whan available?