Re: [SQL] Logging option

From: "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Logging option
Date: 2002-04-03 19:25:50
Message-ID: 00fa01c1db45$5da782d0$110a010a@headquarters.wcgroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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(at)candle(dot)pha(dot)pa(dot)us>
To: "Samuel J. Sutjiono" <ssutjiono(at)wc-group(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>; <pgsql-sql(at)postgresql(dot)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.
> > 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(at)candle(dot)pha(dot)pa(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Luc Lachance 2002-04-03 19:30:46 Re: Postgres and Foxbase
Previous Message Bruce Momjian 2002-04-03 19:07:41 Re: [SQL] Logging option

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-04-03 19:34:31 Re: [SQL] Logging option
Previous Message Bernd von den Brincken 2002-04-03 19:15:44 Named column in a Function fails at ORDER BY (PgSQL 7.1)