gist:6ed85a8a01d2480f807d23639263c4f6

pgsql_dump_all.sh · 529 B · Bash Raw

1	#!/bin/bash
2
3	DATE="$(date +%d)"
4
5	psql_user="postgres"
6	psql_host="/var/run/postgresql/"
7	psql_port="5432"
8
9	[ -f /opt/gitlab/etc/gitlab-psql-rc ] && . /opt/gitlab/etc/gitlab-psql-rc
10
11	su - ${psql_user} -c "pg_dumpall -g --host=${psql_host}" > /var/backups/db_dumps/psql_roles.sql-$DATE
12	gzip -f /var/backups/db_dumps/psql_roles.sql-$DATE
13	su - ${psql_user} -c "pg_dumpall --host=${psql_host}" > /var/backups/db_dumps/pgsqldump-$DATE
14	gzip -f /var/backups/db_dumps/pgsqldump-$DATE
15	find /var/backups/db_dumps/*.gz -mtime +14 -exec rm {} +