[perso/Immae/Projets/Puppet.git] / modules / profile / templates / postgresql / backup_psql.sh.erb

#!/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
Commit	Line	Data
33d0c694 IB	1	#!/bin/bash
	2
	3	set -euo pipefail
	4
	5	resume_replication() {
	6	/usr/bin/psql -h <%= @pg_path %><%= @pg_port_arg %> -c "SELECT pg_wal_replay_resume();" >/dev/null \|\| echo "impossible to resume replication"
	7	}
	8
	9	trap resume_replication EXIT
	10
	11	/usr/bin/psql -h <%= @pg_path %><%= @pg_port_arg %> -c "SELECT pg_wal_replay_pause();" >/dev/null \|\| (echo "impossible to pause replication" && false)
	12
	13	/usr/bin/pg_dumpall -h <%= @pg_path %><%= @pg_port_arg %> -f <%= @pg_backup_path %>/$(date -Iseconds).sql