diff options
author | Daniel Baumann <mail@daniel-baumann.ch> | 2021-12-03 17:21:41 +0000 |
---|---|---|
committer | Daniel Baumann <mail@daniel-baumann.ch> | 2022-02-27 09:14:24 +0000 |
commit | e4cc123a5593d7425be6c25b065b1ffad66953a1 (patch) | |
tree | d319ed8f5927a3a41c6e4bb247ae8de5304c7ff2 /postgresql/bin | |
parent | Releasing version 20220105. (diff) | |
download | service-tools-e4cc123a5593d7425be6c25b065b1ffad66953a1.tar.xz service-tools-e4cc123a5593d7425be6c25b065b1ffad66953a1.zip |
Adding postgresql-tools (WIP).
Signed-off-by: Daniel Baumann <mail@daniel-baumann.ch>
Diffstat (limited to '')
-rwxr-xr-x | postgresql/bin/postgresql-backup | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/postgresql/bin/postgresql-backup b/postgresql/bin/postgresql-backup new file mode 100755 index 0000000..ca2df8d --- /dev/null +++ b/postgresql/bin/postgresql-backup @@ -0,0 +1,26 @@ +#!/bin/sh + +# Open Infrastructure: service-tools + +# Copyright (C) 2014-2021 Daniel Baumann <daniel.baumann@open-infrastructure.net> +# +# SPDX-License-Identifier: GPL-3.0+ +# +# This program is free software: you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation, either version 3 of the License, or +# (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program. If not, see <https://www.gnu.org/licenses/>. + +set -e + +# FIXME +#postgres pg_dump ${DATABASE} | plzip > postgresql-backup/${DATABASE}-"$(date +\%Y\%m\%d)".sql.lz +#find postgresql-backup/ -mtime +90 -name "${DATABASE}-*lz" | xargs -r rm |