waja hat die Gist bearbeitet 6 years ago. Zu Änderung gehen
1 file changed, 15 insertions
pgsql_dump_all.sh(Datei erstellt)
| @@ -0,0 +1,15 @@ | |||
| 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 {} + | |
Neuer
Älter