]>
Commit | Line | Data |
---|---|---|
d0bc90e0 P |
1 | #!/bin/bash |
2 | # {{ ansible_managed }} | |
3 | ||
c95984df P |
4 | set -eo pipefail |
5 | ||
d0bc90e0 P |
6 | BARMAN_DATABASE=$1 |
7 | BARMAN_BACKUP_VERSION=$2 | |
8 | ||
9 | if [[ -z $BARMAN_DATABASE || -z $BARMAN_BACKUP_VERSION ]] | |
10 | then | |
11 | echo "Usage : $0 BARMAN_DATABASE BARMAN_BACKUP_VERSION" >&2 | |
12 | echo " Example: $0 25kv 20161118T002405" >&2 | |
13 | exit 1 | |
14 | fi | |
15 | ||
16 | BACKUP_DATE=`date +%s` | |
17 | ||
18 | echo "accept key if necessary" | |
19 | sudo -u postgres ssh barman@{{ postgres_barman_server }} echo "" | |
20 | ||
21 | echo Stopping PostgreSQL | |
c95984df | 22 | pg_ctlcluster {{ postgres_version }} {{ postgres_cluster_name }} stop || true |
d0bc90e0 P |
23 | |
24 | echo Cleaning up old cluster directory | |
25 | sudo -u postgres mv /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}{,_$BACKUP_DATE} | |
26 | ||
27 | echo Creating new directory | |
28 | sudo -u postgres mkdir -p /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }} | |
29 | ||
30 | echo Get previous backup from backups server | |
31 | sudo -u postgres \ | |
32 | time rsync --progress -pvia --exclude='*.conf' --exclude='server.crt' --exclude='server.key' --delete \ | |
c95984df | 33 | {% if postgres_barman_rsync_enabled|default(false) -%} |
d0bc90e0 | 34 | --password-file=/var/lib/postgresql/.rsync_pass \ |
c95984df P |
35 | {%- endif %} |
36 | {% if postgres_barman_rsync_enabled|default(false) -%}rsync://{%- endif -%}barman@{{ postgres_barman_server }}{%- if postgres_barman_rsync_enabled|default(false) -%}/backups{%- else -%}:~{%- endif -%}/$BARMAN_DATABASE/base/$BARMAN_BACKUP_VERSION/data/ \ | |
d0bc90e0 P |
37 | /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/ |
38 | ||
39 | echo Restoring .conf and server certificate | |
40 | sudo -u postgres cp -a /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}_$BACKUP_DATE/{*.conf,server.crt,server.key} /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/ | |
41 | ||
42 | echo Ensure rights are correcly set | |
43 | chown -R postgres:postgres /var/lib/postgresql/{{ postgres_version }}/ | |
44 | chmod 0700 /var/lib/postgresql/{{ postgres_version }}/ | |
45 | chmod -R o-rwx /var/lib/postgresql/{{ postgres_version }}/ | |
46 | ||
47 | echo Starting PostgreSQL | |
48 | sudo pg_ctlcluster {{ postgres_version }} {{ postgres_cluster_name }} start |