fixes bug in docker

dragarcia · dragarcia · commit 34cc677c0db6 · 2021-07-19T13:50:21.000+08:00
- DB was not starting immediately
diff --git a/ansible/files/docker_mnt/init.sh b/ansible/files/docker_mnt/init.sh
@@ -1 +1,3 @@
-cat /etc/postgresql/postgresql.conf > $PGDATA/postgresql.conf
+cat /etc/postgresql/postgresql.conf > $PGDATA/postgresql.conf
+echo "host replication $POSTGRES_USER 0.0.0.0/0 trust" >> $PGDATA/pg_hba.conf
+echo "host  all  all  127.0.0.1/32  trust" >> $PGDATA/pg_hba.conf
diff --git a/ansible/playbook-docker.yml b/ansible/playbook-docker.yml
@@ -40,7 +40,7 @@
   hosts: localhost
   tasks:
     - name: Commit Docker image
-      command: docker commit "supabase-postgres-build" "supabase/postgres"
+      command: docker commit --change='CMD ["postgres"]' "supabase-postgres-build" "supabase/postgres"
 
 - name: Clean Up Postgres Image
   hosts: localhost
diff --git a/ansible/tasks/docker/setup.yml b/ansible/tasks/docker/setup.yml
@@ -32,15 +32,36 @@
     src: files/postgresql_config/postgresql.conf.j2
     dest: etc/postgresql/postgresql.conf
 
-- name: Setup - import pg_hba.conf
-  template:
-    src: files/postgresql_config/pg_hba.conf.j2
-    dest: etc/postgresql/pg_hba.conf
-
-- name: Setup - import pg_ident.conf
-  template:
-    src: files/postgresql_config/pg_ident.conf.j2
-    dest: etc/postgresql/pg_ident.conf
+- set_fact:
+    regex_string: "#unix_socket_directories = '/tmp'"
+
+- name: Setup - modify unix_socket_directories
+  become: yes
+  replace:
+    path: /etc/postgresql/postgresql.conf
+    regexp: '{{ regex_string }}'
+    replace: unix_socket_directories = '/var/run/postgresql'
+
+- name: Setup - modify unix_socket_directories
+  become: yes
+  replace:
+    path: /etc/postgresql/postgresql.conf
+    regexp: '{{ regex_string }}'
+    replace: unix_socket_directories = '/var/run/postgresql'
+
+- name: Setup - modify hba_file directory
+  become: yes
+  replace:
+    path: /etc/postgresql/postgresql.conf
+    regexp: hba_file = '/etc/postgresql/pg_hba.conf'
+    replace: hba_file = '/var/lib/postgresql/data/pg_hba.conf'
+
+- name: Setup - modify ident_file directory
+  become: yes
+  replace:
+    path: /etc/postgresql/postgresql.conf
+    regexp: ident_file = '/etc/postgresql/pg_ident.conf'
+    replace: ident_file = '/var/lib/postgresql/data/pg_ident.conf'
 
 - name: Setup - add init script to /docker-entrypoint-initdb.d
   synchronize:
