Re: [GENERAL] libpq and PostgreSQL NOTICEs

2001-06-04 Thread Tim Barnard 

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 
  21 | logger -p local5.notice)   /dev/null  21 

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 21 
  
 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])

Re: [GENERAL] libpq and PostgreSQL NOTICEs

2001-06-04 Thread Tom Lane 

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

2001-06-04 Thread Tim Barnard 

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