Logging option
Does anybody know how to prevent this message from being displayed on the screen ? (I just want this message to be logged in the log file). The other question is how do you control the types of error to log ?
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
I appreciate your help.
Samuel J. Sutjiono wrote:
Does anybody know how to prevent this message from being displayed on the screen ? (I just want this message to be logged in the log file). The other question is how do you control the types of error to log ?
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.I appreciate your help.
In 7.3, you will be able to suppress all WARNING messages to the client
with client_min_messages, but in 7.2.X there is no way except modifying
postgres.c. Sorry.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026How about specifying certain types of errors to log in the logfile ? Does
PostgreSQL logs everything in version 7.2.x ?
Thank you very much for your help.
Regards,
Samuel
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Samuel J. Sutjiono" <ssutjiono@wc-group.com>
Cc: <pgsql-general@postgresql.org>; <pgsql-sql@postgresql.org>
Sent: Wednesday, April 03, 2002 2:07 PM
Subject: Re: [GENERAL] [SQL] Logging option
Samuel J. Sutjiono wrote:
Does anybody know how to prevent this message from being displayed on
the screen ? (I just want this message to be logged in the log file). The
other question is how do you control the types of error to log ?
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to
terminate your database system connection and exit.
Show quoted text
Please reconnect to the database system and repeat your query.
I appreciate your help.
In 7.3, you will be able to suppress all WARNING messages to the client
with client_min_messages, but in 7.2.X there is no way except modifying
postgres.c. Sorry.-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
7.3 will have SET/GUC variables server_min_messages and and
client_min_messages which will allow you to control what level of
message appears to the user and server logs. 7.2 can't control that.
---------------------------------------------------------------------------
Samuel J. Sutjiono wrote:
How about specifying certain types of errors to log in the logfile ? Does
PostgreSQL logs everything in version 7.2.x ?
Thank you very much for your help.Regards,
Samuel
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Samuel J. Sutjiono" <ssutjiono@wc-group.com>
Cc: <pgsql-general@postgresql.org>; <pgsql-sql@postgresql.org>
Sent: Wednesday, April 03, 2002 2:07 PM
Subject: Re: [GENERAL] [SQL] Logging optionSamuel J. Sutjiono wrote:
Does anybody know how to prevent this message from being displayed on
the screen ? (I just want this message to be logged in the log file). The
other question is how do you control the types of error to log ?NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend diedabnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to
terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
I appreciate your help.
In 7.3, you will be able to suppress all WARNING messages to the client
with client_min_messages, but in 7.2.X there is no way except modifying
postgres.c. Sorry.-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026