Re: [SQL] Logging option
От | Samuel J. Sutjiono |
---|---|
Тема | Re: [SQL] Logging option |
Дата | |
Msg-id | 00fa01c1db45$5da782d0$110a010a@headquarters.wcgroup.com обсуждение исходный текст |
Ответ на | Re: [SQL] Logging option (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: [SQL] Logging option
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: