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.rossi@xxxxxxxxxxx
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099
-----Original Message-----
From: Igor Neyman [mailto:ineyman@xxxxxxxxxxxxxx]
Sent: Thursday, March 12, 2015 12:11 PM
To: Rossi, Maria; 'Shreeyansh Dba'; gilberto.castillo@xxxxxxxxx
Cc: Postgres Maillist
Subject: RE: Errorlog empty
> -----Original Message-----
> From: Rossi, Maria [mailto:maria.rossi@xxxxxxxxxxx]
> Sent: Thursday, March 12, 2015 11:55 AM
> To: Igor Neyman; 'Shreeyansh Dba'; gilberto.castillo@xxxxxxxxx
> Cc: Postgres Maillist
> Subject: RE: Errorlog empty
>
> It is 'on'.
>
> postgres=# show logging_collector;
> logging_collector
> -------------------
> on
> (1 row)
>
> postgres=#
>
>
>
> Maria
>
> -----Original Message-----
> From: Igor Neyman [mailto:ineyman@xxxxxxxxxxxxxx]
> Sent: Thursday, March 12, 2015 11:52 AM
> To: Rossi, Maria; 'Shreeyansh Dba'; gilberto.castillo@xxxxxxxxx
> Cc: Postgres Maillist
> Subject: RE: Errorlog empty
>
> From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-
> owner@xxxxxxxxxxxxxx] On Behalf Of Rossi, Maria
> Sent: Thursday, March 12, 2015 11:29 AM
> To: 'Shreeyansh Dba'; gilberto.castillo@xxxxxxxxx
> Cc: Postgres Maillist
> Subject: Re: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
