From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] Logging option |
Date: | 2002-04-03 19:34:31 |
Message-ID: | 200204031934.g33JYVj16912@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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(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
> >
>
>
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Lane | 2002-04-03 20:03:21 | Re: Postgres/PHP, Apache child processes dying |
Previous Message | Jean-Luc Lachance | 2002-04-03 19:30:46 | Re: Postgres and Foxbase |
From | Date | Subject | |
---|---|---|---|
Next Message | Travis Hoyt | 2002-04-03 20:15:02 | date manipulation |
Previous Message | Samuel J. Sutjiono | 2002-04-03 19:25:50 | Re: [SQL] Logging option |