dbTalk Databases Forums  

Need to Suppress Output to Console

comp.databases.postgresql comp.databases.postgresql


Discuss Need to Suppress Output to Console in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Artist
 
Posts: n/a

Default Need to Suppress Output to Console - 02-02-2009 , 10:18 AM






I am using Postgersql 8.2.11-1 on Windows XP. When Postresql is in use
it outputs a lot of text to the console window. Every query and and
every query result is output there. I need this output only when
debugging and since outputting this has to cost processor time I need a
way to turn this off. How is this done?

--
If you desire to respond directly remove the "sj." from the domain name
part of my email address. It is a spam jammer.

Reply With Quote
  #2  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Need to Suppress Output to Console - 02-17-2009 , 04:28 AM






Artist <Artist (AT) sj (DOT) speakeasy.net> wrote:
Quote:
I am using Postgersql 8.2.11-1 on Windows XP. When Postresql is in use
it outputs a lot of text to the console window. Every query and and
every query result is output there. I need this output only when
debugging and since outputting this has to cost processor time I need a
way to turn this off. How is this done?
I don't know about Windows, but does this also happen if you run the
database server as a Windows service?

Log output should go to the log file only.
There are configuration parameters that let you determine what and how much
will be logged.

Yours,
Laurenz Albe


Reply With Quote
  #3  
Old   
Thomas Kellerer
 
Posts: n/a

Default Re: Need to Suppress Output to Console - 02-17-2009 , 04:50 AM



Artist, 02.02.2009 17:18:
Quote:
I am using Postgersql 8.2.11-1 on Windows XP. When Postresql is in use
it outputs a lot of text to the console window. Every query and and
every query result is output there. I need this output only when
debugging and since outputting this has to cost processor time I need a
way to turn this off. How is this done?

If you run Postgres as a service, this won't happen.

If you don't want or cannot run it as a service (which seems rather strange) simply adjust the logging settings in postgresql.conf

Check out:
http://www.postgresql.org/docs/curre...g-logging.html

Thomas




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.