Turning on/off debugging

From: John Gibson <gib(at)edgate(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Turning on/off debugging
Date: 2003-12-08 16:46:19
Message-ID: 3FD4AADB.4040407@edgate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, all.

Re: version 7.2.2

I modified the postgresql.conf file as below and got "really neat"
debugging turned on. :)
pg_ctl reload -D <dir>

Unfortunately after I was done, I wanted to turn it off again. I
commented out the lines and ran the "reload" again. This did not have
any effect. So, I thought it might just be a switch and set them to
false and reloaded. This did not change it back either. I ended up
shutting down the engine and restarting it. Of course, that worked.

Any ideas on how to do it while the engine is running?

...john

*** DETAIL ***

log_timestamp = true
log_pid = true
debug_print_query = true

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-08 16:54:57 Re: CREATE RULE problem/question requesting workaround
Previous Message Rich Hall 2003-12-08 16:14:55 Re: Stored FUnctions