1 files changed, 19 insertions, 0 deletions

diff --git a/hetzner/psql.yaml b/hetzner/psql.yaml
new file mode 100644
index 0000000..4941ea9
--- /dev/null
+++ b/hetzner/psql.yaml
@@ -0,0 +1,19 @@
+---
+- name: Postgresql
+  hosts: localhost
+  become: true
+  become_user: postgres
+  tasks:
+    - name: Create Mastodon Database
+      community.postgresql.postgresql_db:
+          name: mastodon_production
+          encoding: UTF-8
+          lc_collate: en_US.UTF-8
+          lc_ctype: en_US.UTF-8
+          template: template0
+
+    - name: Create Postgresql User
+      community.postgresql.postgresql_user:
+        db: mastodon_production
+        user: mastodon
+        password: