aboutsummaryrefslogtreecommitdiff
path: root/modules/profile/templates/postgresql/backup_psql.sh.erb
blob: cf353b04a98bc453d888ef82584cb850b4f80646 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
#!/bin/bash

set -euo pipefail

resume_replication() {
  /usr/bin/psql -h <%= @pg_path %><%= @pg_port_arg %> -c "SELECT pg_wal_replay_resume();" >/dev/null || echo "impossible to resume replication"
}

trap resume_replication EXIT

/usr/bin/psql -h <%= @pg_path %><%= @pg_port_arg %> -c "SELECT pg_wal_replay_pause();" >/dev/null || (echo "impossible to pause replication" && false)

/usr/bin/pg_dumpall -h <%= @pg_path %><%= @pg_port_arg %> -f <%= @pg_backup_path %>/$(date -Iseconds).sql