From ssutjiono@wc-group.com Wed Apr 3 15:05:09 2002 Received: from qmsql.netservers.net (hpmail1.netservers.net [209.196.128.163]) by postgresql.org (Postfix) with SMTP id 7051947593E for ; Wed, 3 Apr 2002 10:05:09 -0500 (EST) Received: (qmail 65953 invoked from network); 3 Apr 2002 15:05:09 -0000 Received: from unknown (HELO AARON) (66.26.63.73) by hpmail1.netservers.net with SMTP; 3 Apr 2002 15:05:09 -0000 Message-ID: <005a01c1db20$2771f260$110a010a@headquarters.wcgroup.com> From: "Samuel J. Sutjiono" To: , Subject: Logging option Date: Wed, 3 Apr 2002 09:59:28 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0057_01C1DAF6.3E3A1B50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/109 X-Sequence-Number: 22832 This is a multi-part message in MIME format. ------=_NextPart_000_0057_01C1DAF6.3E3A1B50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anybody know how to prevent this message from being displayed on the s= creen ? (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 abnorm= ally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminat= e your database system connection and exit. Please reconnect to the database system and repeat your query. I appreciate your help. ------=_NextPart_000_0057_01C1DAF6.3E3A1B50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Does anybody know how to prevent this mess= age from=20 being displayed on the screen ? (I just want this message to be logged in t= he=20 log file). The other question is how do you control the types of error to l= og=20 ?
 
NOTICE:  Message from PostgreSQL=20 backend:
        The Postmaster has= =20 informed me that some other backend  died abnormally and possibly corr= upted=20 shared memory.
        I have rolled = back=20 the current transaction and am going to terminate your database system=20 connection and exit.
        Please= =20 reconnect to the database system and repeat your query.
 
I appreciate your help.
 
------=_NextPart_000_0057_01C1DAF6.3E3A1B50-- From pgman@candle.pha.pa.us Wed Apr 3 19:07:46 2002 Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id 58F00475AD1; Wed, 3 Apr 2002 14:07:46 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g33J7f212383; Wed, 3 Apr 2002 14:07:41 -0500 (EST) From: Bruce Momjian Message-Id: <200204031907.g33J7f212383@candle.pha.pa.us> Subject: Re: [SQL] Logging option In-Reply-To: <005a01c1db20$2771f260$110a010a@headquarters.wcgroup.com> To: "Samuel J. Sutjiono" Date: Wed, 3 Apr 2002 14:07:41 -0500 (EST) Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL97 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200204/123 X-Sequence-Number: 22846 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 19026 From ssutjiono@wc-group.com Wed Apr 3 19:31:36 2002 Received: from qmsql.netservers.net (hpmail1.netservers.net [209.196.128.163]) by postgresql.org (Postfix) with SMTP id 52F73475C8A for ; Wed, 3 Apr 2002 14:31:36 -0500 (EST) Received: (qmail 63141 invoked from network); 3 Apr 2002 19:31:32 -0000 Received: from unknown (HELO AARON) (66.26.63.73) by hpmail1.netservers.net with SMTP; 3 Apr 2002 19:31:32 -0000 Message-ID: <00fa01c1db45$5da782d0$110a010a@headquarters.wcgroup.com> From: "Samuel J. Sutjiono" To: "Bruce Momjian" Cc: , References: <200204031907.g33J7f212383@candle.pha.pa.us> Subject: Re: [SQL] Logging option Date: Wed, 3 Apr 2002 14:25:50 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/125 X-Sequence-Number: 22848 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" To: "Samuel J. Sutjiono" Cc: ; 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. > > 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 > From pgman@candle.pha.pa.us Wed Apr 3 19:34:33 2002 Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id 74665475A90; Wed, 3 Apr 2002 14:34:33 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g33JYVj16912; Wed, 3 Apr 2002 14:34:31 -0500 (EST) From: Bruce Momjian Message-Id: <200204031934.g33JYVj16912@candle.pha.pa.us> Subject: Re: [SQL] Logging option In-Reply-To: <00fa01c1db45$5da782d0$110a010a@headquarters.wcgroup.com> To: "Samuel J. Sutjiono" Date: Wed, 3 Apr 2002 14:34:31 -0500 (EST) Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL97 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200204/126 X-Sequence-Number: 22849 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" > To: "Samuel J. Sutjiono" > Cc: ; > 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. > > > 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