By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,299 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

Help with Turning debugging on/off

P: n/a
Hi, all.

Re: 7.2.2

I modified the postgresql.conf file to enable some debugging. I then
did pg_ctl reload -D "blah". That got the debugging started. But when
I tried to turn it off, it does not seem to want to stop debugging. I
tried just commenting the lines out, then I tried explicitly changing
them from true to false. Neither seems to turn the debugging off. I
did the pg_ctl reload after each change I tried.

Any ideas, 'cause I am puzzled.

....john

*** DETAIL ***
log_timestamp = true
log_pid = true
debug_print_query = true


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi cadancer,

cadancer schrieb:
Hi, all.

Re: 7.2.2

I modified the postgresql.conf file to enable some debugging. I then
did pg_ctl reload -D "blah". That got the debugging started. But when
I tried to turn it off, it does not seem to want to stop debugging. I
tried just commenting the lines out, then I tried explicitly changing
them from true to false. Neither seems to turn the debugging off. I
did the pg_ctl reload after each change I tried.


Unfortunately you have to restart the database to enable/disable
logging. Dont ask me why...

Regards
Tino Wildenhain
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.