From a5424777ff21386c3cb6921109960dc5f4a32191 Mon Sep 17 00:00:00 2001 From: "nils.wagner" Date: Mon, 4 Apr 2016 11:26:56 +0200 Subject: [PATCH] =?utf8?q?spk-taiga=20-=20crons=20f=C3=BCr=20pgsql=20backu?= =?utf8?q?p?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- .../taiga-sparkasse-de.pixelpark.net.yaml | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) diff --git a/customer/spk-taiga/taiga-sparkasse-de.pixelpark.net.yaml b/customer/spk-taiga/taiga-sparkasse-de.pixelpark.net.yaml index c722bc7f..31289899 100644 --- a/customer/spk-taiga/taiga-sparkasse-de.pixelpark.net.yaml +++ b/customer/spk-taiga/taiga-sparkasse-de.pixelpark.net.yaml @@ -138,6 +138,14 @@ site::profile::postgresql_server::databases: user: taiga password: ENC[PKCS7,MIIBeQYJKoZIhvcNAQcDoIIBajCCAWYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEApUqZw7pGOPLIgAdPwPWpVCL6mCVciZdjrP1AcK7uVIFZ8y43Ce0QmrD9JWYyUnM+IdAHZRS8HR5XUSuSiDnx5+UOPW5VSVuJIWLmp5x+V022RFYqDgS+lz6Qtj0CLEIbuchjpcNA+tsA8eI64UZgCdEjkIvxFd4HumkjOWElYZ0mCDDAJKo+qxfZg5hGCd0N9Z8i2jm/rMoZ5UqL3P1BFPEr07j35GpP5rsLROGYe+hKzpLJYsO6uZowYRSM5KsTbx1MafxAY7lwp5F+BwU4sEU6QBCw4gBzPm5iEXuiU/ItDDG+Jf+0/Y0qEMucwX1iHpUqu2LISX7oMYNslcx4sjA8BgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCRXWs77ceTsvr+3MQvqvBugBA0TTwvAPrFUcKf5ZwlVoek] -#site::profile::cron: -# postgres_dump: -# command: / +site::profile::cron: + postgres_backup_create: + command: /usr/pgsql-9.5/bin/pg_dump taiga > /var/backup/taiga-$(date +%Y-%m-%d).sql + minute: 00 + hour: 4 + user: postgres + postgres_backup_remove: + command: find /var/backup/ -name "taiga-*.sql" -type f -ctime +7 -exec rm -f {} \; + minute: 00 + hour: 22 + user: postgres -- 2.39.5