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 >