From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
---|---|
To: | "Rossi, Maria" <maria(dot)rossi(at)us(dot)pgds(dot)com>, 'Shreeyansh Dba' <shreeyansh2014(at)gmail(dot)com>, "gilberto(dot)castillo(at)etecsa(dot)cu" <gilberto(dot)castillo(at)etecsa(dot)cu> |
Cc: | Postgres Maillist <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Errorlog empty |
Date: | 2015-03-12 16:11:21 |
Message-ID: | A76B25F2823E954C9E45E32FA49D70ECCD3EE263@mail.corp.perceptron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> -----Original Message-----
> From: Rossi, Maria [mailto:maria(dot)rossi(at)us(dot)pgds(dot)com]
> Sent: Thursday, March 12, 2015 11:55 AM
> To: Igor Neyman; 'Shreeyansh Dba'; gilberto(dot)castillo(at)etecsa(dot)cu
> Cc: Postgres Maillist
> Subject: RE: [ADMIN] Errorlog empty
>
> It is 'on'.
>
> postgres=# show logging_collector;
> logging_collector
> -------------------
> on
> (1 row)
>
> postgres=#
>
>
>
> Maria
>
> -----Original Message-----
> From: Igor Neyman [mailto:ineyman(at)perceptron(dot)com]
> Sent: Thursday, March 12, 2015 11:52 AM
> To: Rossi, Maria; 'Shreeyansh Dba'; gilberto(dot)castillo(at)etecsa(dot)cu
> Cc: Postgres Maillist
> Subject: RE: [ADMIN] Errorlog empty
>
> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-
> owner(at)postgresql(dot)org] On Behalf Of Rossi, Maria
> Sent: Thursday, March 12, 2015 11:29 AM
> To: 'Shreeyansh Dba'; gilberto(dot)castillo(at)etecsa(dot)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’, but still 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
What about other parameters?
Log_destination
Log_filename
Log_directory
Log_connections
Log_disconnections
Regards,
Igor Neyman
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Frost | 2015-03-12 16:41:42 | Re: pg_repack 1.3.1 RPM whan available? |
Previous Message | Jiří Hlinka | 2015-03-12 16:05:32 | pg_repack 1.3.1 RPM whan available? |