Re: Errorlog empty

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux