pgsql_dump_all.sh
· 529 B · Bash
Raw
#!/bin/bash
DATE="$(date +%d)"
psql_user="postgres"
psql_host="/var/run/postgresql/"
psql_port="5432"
[ -f /opt/gitlab/etc/gitlab-psql-rc ] && . /opt/gitlab/etc/gitlab-psql-rc
su - ${psql_user} -c "pg_dumpall -g --host=${psql_host}" > /var/backups/db_dumps/psql_roles.sql-$DATE
gzip -f /var/backups/db_dumps/psql_roles.sql-$DATE
su - ${psql_user} -c "pg_dumpall --host=${psql_host}" > /var/backups/db_dumps/pgsqldump-$DATE
gzip -f /var/backups/db_dumps/pgsqldump-$DATE
find /var/backups/db_dumps/*.gz -mtime +14 -exec rm {} +
| 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 {} + |