Thread: Log details are displaying on the console
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.
-----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.