fix: execute sql files after PG startup (#166)

darora · web-flow · commit e7b8a79090d5 · 2022-03-24T22:38:41.000+08:00
diff --git a/ansible/playbook.yml b/ansible/playbook.yml
@@ -9,6 +9,7 @@
 
   vars:
     sql_files:
+      - { source: "pgbouncer_config/pgbouncer_auth_schema.sql", dest: "00-schema.sql" }
       - { source: "stat_extension.sql", dest: "01-extension.sql" }
 
   environment:
diff --git a/ansible/tasks/setup-pgbouncer.yml b/ansible/tasks/setup-pgbouncer.yml
@@ -109,18 +109,6 @@
     - "host  all  pgbouncer  127.0.0.1/32  scram-sha-256"
     - "# Connection configuration for pgbouncer user"
 
-# Run PgBouncer SQL script
-- name: Transfer init SQL files
-  copy:
-    src: files/pgbouncer_config/pgbouncer_auth_schema.sql
-    dest: /tmp/00-schema.sql
-
-- name: Execute init SQL files
-  become: yes
-  become_user: postgres
-  shell:
-    cmd: /usr/lib/postgresql/bin/psql -f /tmp/00-schema.sql
-
 # Add fail2ban filter
 - name: import jail.d/pgbouncer.conf
   template:
