Re: [GENERAL] libpq and PostgreSQL NOTICEs
The 'client' side. Thanks, I'll give it a try. Tim - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Tim Barnard" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, June 04, 2001 1:40 PM Subject: Re: [GENERAL] libpq and PostgreSQL NOTICEs > "Tim Barnard" <[EMAIL PROTECTED]> writes: > > Is there any way to force Postgre not to send NOTICEs to the console? > > Define "console" --- you mean the client's stderr? Or the postmaster's? > > Changing libpq's notice processor (see PQsetNoticeProcessor) would help > if you want to filter notices on the client side. > > regards, tom lane > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] libpq and PostgreSQL NOTICEs
"Tim Barnard" <[EMAIL PROTECTED]> writes: > Is there any way to force Postgre not to send NOTICEs to the console? Define "console" --- you mean the client's stderr? Or the postmaster's? Changing libpq's notice processor (see PQsetNoticeProcessor) would help if you want to filter notices on the client side. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] libpq and PostgreSQL NOTICEs
Hmm, well it is, or appears to be. Here's how postmaster starts: su - cvms -c "(/usr/local/pgsql/bin/postmaster -D/progs/db -B 256 2>&1 | logger -p local5.notice) &" > /dev/null 2>&1 & Problem is, NOTICE's still goes to the console. Any other ideas? This is really driving me bonkers!?!?! :-) Tim - Original Message - From: "Andrew Sullivan" <[EMAIL PROTECTED]> To: "Tim Barnard" <[EMAIL PROTECTED]> Sent: Monday, June 04, 2001 11:23 AM Subject: Re: [GENERAL] libpq and PostgreSQL NOTICEs > On Mon, Jun 04, 2001 at 10:59:14AM -0700, Tim Barnard wrote: > > rather than spewing across the screen. Does anyone know if and how > > to instruct Postgre to send its NOTICEs to a log file? > > Sure. When starting postgres, send its output to a file: > > postmaster [stuff] > /some/log 2>&1 & > > That's if you're using a Bourne-style shell. > > A > > -- > > Andrew Sullivan 87 Mowat Avenue > Liberty RMS Toronto, Ontario Canada > <[EMAIL PROTECTED]> M6K 3E3 > +1 416 646 3306 x110 > > ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])