Re: Errorlog empty

Igor,

Here's the other 'log' configs: Thanks.

postgres=# show log_destination;
log_destination
-----------------
stderr
(1 row)

postgres=# show log_filename;
log_filename
---------------
gp07error.log
(1 row)

postgres=# show log_directory;
log_directory
-----------------------------
/dba/pgsql/gp07/pg_errorlog
(1 row)

postgres=# show log_connections;
log_connections
-----------------
on
(1 row)

postgres=# show log_disconnections;
log_disconnections
--------------------
on
(1 row)

postgres=#

Maria A Rossi
Database Administration
PGDS (US)
email: maria(dot)rossi(at)us(dot)pgds(dot)com
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099

-----Original Message-----
From: Igor Neyman [mailto:ineyman(at)perceptron(dot)com]
Sent: Thursday, March 12, 2015 12:11 PM
To: Rossi, Maria; 'Shreeyansh Dba'; gilberto(dot)castillo(at)etecsa(dot)cu
Cc: Postgres Maillist
Subject: RE: [ADMIN] Errorlog empty

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