Enable statement logging

darora · darora · commit 7ecf5de57793 · 2021-10-19T09:19:35.000+05:30
Additionally, enable logrotation on csv logs to cope with increased
log sizes.
diff --git a/ansible/files/logrotate-postgres-csv b/ansible/files/logrotate-postgres-csv
@@ -0,0 +1,11 @@
+/var/lib/postgresql/data/pg_log/postgresql.csv {
+    size 50M
+    rotate 9
+    compress
+    delaycompress
+    notifempty
+    missingok
+    postrotate
+        sudo -u postgres pg_ctl -D /var/lib/postgresql/data logrotate
+    endscript
+}
diff --git a/ansible/files/postgresql_config/postgresql.conf.j2 b/ansible/files/postgresql_config/postgresql.conf.j2
@@ -570,7 +570,7 @@ log_line_prefix = '%h %m [%p] %q%u@%d '		# special values:
 #log_parameter_max_length_on_error = 0	# when logging an error, limit logged
 					# bind-parameter values to N bytes;
 					# -1 means print in full, 0 disables
-#log_statement = 'none'			# none, ddl, mod, all
+log_statement = 'all'			# none, ddl, mod, all
 #log_replication_commands = off
 #log_temp_files = -1			# log temporary files equal or larger
 					# than the specified size in kilobytes;
diff --git a/ansible/playbook.yml b/ansible/playbook.yml
@@ -96,6 +96,11 @@
         src: files/logrotate-postgres
         dest: /etc/logrotate.d/postgres
 
+    - name: Setup logrotate for postgres CSV logs
+      copy:
+        src: files/logrotate-postgres-csv
+        dest: /etc/logrotate.d/postgres-csv
+
     - name: Configure logrotation to run every hour
       shell:
         cmd: mv /etc/cron.daily/logrotate /etc/cron.hourly/
