Default to not logging any statements when setting up the database. I
think it's basically harmful; it slows things down, takes up huge
amounts of disk space and is unnecessary 99% of the time. It's easy to
turn on again for a session, user or database, e.g.:
SET log_statement TO 'all';
ALTER ROLE launchpad SET log_statement TO 'all';
ALTER DATABASE launchpad_dev SET log_statement TO 'all';
Default to not logging any statements when setting up the database. I
think it's basically harmful; it slows things down, takes up huge
amounts of disk space and is unnecessary 99% of the time. It's easy to
turn on again for a session, user or database, e.g.:
SET log_statement TO 'all';
ALTER ROLE launchpad SET log_statement TO 'all';
ALTER DATABASE launchpad_dev SET log_statement TO 'all';
[ http:// www.postgresql. org/docs/ 8.3/static/ sql-set. html www.postgresql. org/docs/ 8.3/static/ sql-alterrole. html www.postgresql. org/docs/ 8.3/static/ sql-alterdataba se.html ]
http://
http://
It's also possible to trace statements using Storm:
from storm.tracer import debug; debug(True)
[ https:/ /dev.launchpad. net/Debugging ]