From dab5b4f8980bfb87660b34a534920fdaf518742e Mon Sep 17 00:00:00 2001 From: Jakub Czajka Date: Wed, 27 Sep 2023 23:23:31 +0200 Subject: [PATCH] Add a script for restoring database. --- install/database_from_save.yaml | 12 ++++++++++++ turnup.yaml | 5 +++++ 2 files changed, 17 insertions(+) create mode 100644 install/database_from_save.yaml diff --git a/install/database_from_save.yaml b/install/database_from_save.yaml new file mode 100644 index 0000000..df87393 --- /dev/null +++ b/install/database_from_save.yaml @@ -0,0 +1,12 @@ +# Copyright (c) 2023 Jakub Czajka +# License: GPL-3.0 or later. + +- hosts: servers + tasks: + - name: Restart postgresql + service: + name: postgresql + state: restarted + become: yes + - name: Restore database from backup + command: psql --username=postgres --file=/tmp/database diff --git a/turnup.yaml b/turnup.yaml index be39912..acc12d1 100644 --- a/turnup.yaml +++ b/turnup.yaml @@ -30,6 +30,9 @@ - name: Deploy server import_playbook: server.yaml +- name: Recreate database + import_playbook: database.yaml + - name: Deploy cv import_playbook: cv.yaml @@ -44,3 +47,5 @@ - name: Deploy yt-dlp server import_playbook: yt_dlp_server.yaml + +- import_playbook: install/database_from_save.yaml -- 2.39.5