Re: Errorlog empty

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

In response to

Responses

Browse pgsql-admin by date

  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?