Update PG logging config

darora · darora · commit d8e72b5c911a · 2021-10-20T17:06:13.000+05:30
diff --git a/ansible/files/logrotate-postgres b/ansible/files/logrotate-postgres
@@ -1,4 +1,4 @@
-/var/lib/postgresql/data/pg_log/postgresql.log {
+/var/log/postgresql/postgresql.log {
     size 50M
     rotate 3  
     copytruncate
diff --git a/ansible/files/logrotate-postgres-csv b/ansible/files/logrotate-postgres-csv
@@ -1,4 +1,4 @@
-/var/lib/postgresql/data/pg_log/postgresql.csv {
+/var/log/postgresql/postgresql.csv {
     size 50M
     rotate 9
     compress
diff --git a/ansible/files/postgresql_config/postgresql.conf.j2 b/ansible/files/postgresql_config/postgresql.conf.j2
@@ -440,11 +440,11 @@ logging_collector = on		# Enable capturing of stderr and csvlog
 					# (change requires restart)
 
 # These are only used if logging_collector is on:
-log_directory = 'pg_log'			# directory where log files are written,
+log_directory = '/var/log/postgresql'			# directory where log files are written,
 					# can be absolute or relative to PGDATA
 log_filename = 'postgresql.log'	# log file name pattern,
 					# can include strftime() escapes
-# log_file_mode = 0600			# creation mode for log files,
+log_file_mode = 0640			# creation mode for log files,
 					# begin with 0 to use octal notation
 log_rotation_age = 0			# Automatic rotation of logfiles will
 					# happen after that time.  0 disables.
@@ -791,4 +791,4 @@ jit_provider = 'llvmjit'		# JIT library to use
 # CUSTOMIZED OPTIONS
 #------------------------------------------------------------------------------
 
-# Add settings for extensions here
+# Add settings for extensions here
diff --git a/ansible/tasks/setup-postgres.yml b/ansible/tasks/setup-postgres.yml
@@ -103,6 +103,14 @@
     owner: postgres
     group: postgres
 
+- name: Create logs dir
+  become: yes
+  file:
+    path: /var/log/postgresql
+    state: directory
+    owner: postgres
+    group: postgres
+
 # Move Postgres configuration files into /etc/postgresql
 # Add postgresql.conf
 - name: import postgresql.conf
@@ -131,7 +139,7 @@
   register: postgresql_bin
 
 - name: Create symbolic links for Postgres binaries to /usr/bin/
-  become: True
+  become: yes
   file:
     src: "{{ item.path }}"
     path: "/usr/bin/{{ item.path | basename }}"
diff --git a/ansible/tasks/setup-supabase-internal.yml b/ansible/tasks/setup-supabase-internal.yml
@@ -39,6 +39,12 @@
     deb: "{{ vector_arm_deb }}"
   when: platform == "arm64"
 
+- name: add Vector to postgres group
+  become: yes
+  shell:
+    cmd: |
+      usermod -a -G postgres vector
+
 - name: Install Postgres exporter
   import_tasks: internal/postgres-exporter.yml
 

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-/var/lib/postgresql/data/pg_log/postgresql.log {`
	`1`	`+/var/log/postgresql/postgresql.log {`
`2`	`2`	`size 50M`
`3`	`3`	`rotate 3`
`4`	`4`	`copytruncate`
Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-/var/lib/postgresql/data/pg_log/postgresql.csv {`
	`1`	`+/var/log/postgresql/postgresql.csv {`
`2`	`2`	`size 50M`
`3`	`3`	`rotate 9`
`4`	`4`	`compress`