Обсуждение: Logging option
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.
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.
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 loggedin 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
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 >
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