pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Logging option
4+ messages / 2 participants
[nested] [flat]

* Logging option
@ 2002-04-03 14:59  Samuel J. Sutjiono <ssutjiono@wc-group.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Samuel J. Sutjiono @ 2002-04-03 14:59 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-sql

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.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Logging option
@ 2002-04-03 19:07  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: Samuel J. Sutjiono <ssutjiono@wc-group.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruce Momjian @ 2002-04-03 19:07 UTC (permalink / raw)
  To: Samuel J. Sutjiono <ssutjiono@wc-group.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Logging option
@ 2002-04-03 19:25  Samuel J. Sutjiono <ssutjiono@wc-group.com>
  parent: Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Samuel J. Sutjiono @ 2002-04-03 19:25 UTC (permalink / raw)
  To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-general@postgresql.org; 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@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.
> >         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
>




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Logging option
@ 2002-04-03 19:34  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: Samuel J. Sutjiono <ssutjiono@wc-group.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2002-04-03 19:34 UTC (permalink / raw)
  To: Samuel J. Sutjiono <ssutjiono@wc-group.com>; +Cc: pgsql-general@postgresql.org; 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@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.
> > >         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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2002-04-03 19:34 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-03 14:59 Logging option Samuel J. Sutjiono <ssutjiono@wc-group.com>
2002-04-03 19:07 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-04-03 19:25   ` Samuel J. Sutjiono <ssutjiono@wc-group.com>
2002-04-03 19:34     ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox