Initial commit open sourcing Postgresql Ansible role1.0.0

1 files changed, 16 insertions, 0 deletions

diff --git a/templates/logrotate-postgresql-common.j2 b/templates/logrotate-postgresql-common.j2
new file mode 100644
index 0000000..06245b6
--- /dev/null
+++ b/templates/logrotate-postgresql-common.j2
@@ -0,0 +1,16 @@
+{{ postgres_log_dir|default('/var/log/postgresql') }}/*.log
+{
+       daily
+       rotate 60
+       copytruncate
+       delaycompress
+       compress
+       notifempty
+       missingok
+       su root root
+{% if postgres_pgbadger_server is defined and postgres_pgbadger_server %}
+       lastaction
+          /root/scripts/pgBadger.sh
+       endscript
+{% endif -%}
+}