From: Kevin Fenzi <kevin(a)scrye.com>
I'd like to log queries on db-koji01 for a short time to try and see whats causing us
such pain.
After we have collected a bunch of queries we can revert this until we sort out what
needs
to be changed. We may also change this log all to log just slow queries (per smooge's
suggestion).
Hopefully this will get us the info we need to track this down.
Signed-off-by: Kevin Fenzi <kevin(a)scrye.com>
---
roles/postgresql_server/templates/postgresql.conf | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/roles/postgresql_server/templates/postgresql.conf
b/roles/postgresql_server/templates/postgresql.conf
index 00320a8..c38a2fd 100644
--- a/roles/postgresql_server/templates/postgresql.conf
+++ b/roles/postgresql_server/templates/postgresql.conf
@@ -268,7 +268,7 @@ log_truncate_on_rotation = on # If on, an existing log file
of the
# in all cases.
log_rotation_age = 1d # Automatic rotation of logfiles will
# happen after that time. 0 to disable.
-log_rotation_size = 0 # Automatic rotation of logfiles will
+log_rotation_size = 10000 # Automatic rotation of logfiles will
# happen after that much log output.
# 0 to disable.
@@ -357,8 +357,8 @@ log_checkpoints = on
# processes
# %% = '%'
# e.g. '<%u%%%d> '
-#log_lock_waits = off # log lock waits >= deadlock_timeout
-#log_statement = 'none' # none, ddl, mod, all
+log_lock_waits = on # log lock waits >= deadlock_timeout
+log_statement = 'all' # none, ddl, mod, all
log_temp_files = 0 # log temporary files equal or larger
# than specified size;
# -1 disables, 0 logs all temp files
--
1.8.3.1