Thread: Log details are displaying on the console

Log details are displaying on the console

From
"Suresh Gupta VG"
Date:

Hi All,

 

All the logging details of pgsql are displaying on the console itself. Pls see the below output. Is there any option in the configuration files to disable it.?

 

bash-2.05$ ps -ef |grep postgres

   pgsql 17915 17913  0 12:51:13 ?        0:00 /db1/postgresql/bin/postgres -D /db1/postgresql/data -i

   pgsql 17916 17913  0 12:51:13 ?        0:00 /db1/postgresql/bin/postgres -D /db1/postgresql/data -i

   pgsql 17918 17436  0 12:51:22 pts/3    0:00 grep postgres

   pgsql 17913     1  1 12:51:13 pts/3    0:00 /db1/postgresql/bin/postgres -D /db1/postgresql/data -i

bash-2.05$ WARNING:  there is no transaction in progress

WARNING:  there is no transaction in progress

WARNING:  there is no transaction in progress

LOG:  unexpected EOF on client connection

WARNING:  there is no transaction in progress

WARNING:  there is no transaction in progress

WARNING:  there is no transaction in progress

WARNING:  there is no transaction in progress

FATAL:  sorry, too many clients already

WARNING:  there is no transaction in progress

WARNING:  there is no transaction in progress

WARNING:  there is no transaction in progress

FATAL:  sorry, too many clients already

LOG:  unexpected EOF on client connection

WARNING:  there is no transaction in progress

FATAL:  sorry, too many clients already

WARNING:  there is no transaction in progress

FATAL:  sorry, too many clients already

FATAL:  sorry, too many clients already

FATAL:  sorry, too many clients already

FATAL:  sorry, too many clients already

FATAL:  sorry, too many clients already

FATAL:  sorry, too many clients already

FATAL:  sorry, too many clients already

 

 

--Suresh

DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails.

Re: Log details are displaying on the console

From
"Phillip Smith"
Date:
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Suresh Gupta VG
Sent: Tuesday, 19 February 2008 21:17
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Log details are displaying on the console

> All the logging details of pgsql are displaying on the console itself. Pls
see the
> below output. Is there any option in the configuration files to disable
it.?

Have a look in postgresql.conf in your data directory under the heading:

#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------


Specifically these settings:
    log_destination
    redirect_stderr


THINK BEFORE YOU PRINT - Save paper if you don't really need to print this

*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to
the addressee.  If you are not the addressee indicated in this message or
responsible for delivery of the message to such person, you may not copy
or deliver this message to anyone, and you should destroy it and kindly
notify the sender by reply email.

Information in this message that does not relate to the official business
of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta.
Weatherbeeta, its employees, contractors or associates shall not be liable
for direct, indirect or consequential loss arising from transmission of this
message or any attachments
e-mail.