From 2841b9e03519aacfee6cc7347d2380bf27af053d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 30 Apr 2022 23:23:16 +0200 Subject: postgresql Signed-off-by: Daniel Baumann --- postgresql/bin/postgresql-backup | 47 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 47 insertions(+) create mode 100755 postgresql/bin/postgresql-backup (limited to 'postgresql/bin/postgresql-backup') diff --git a/postgresql/bin/postgresql-backup b/postgresql/bin/postgresql-backup new file mode 100755 index 0000000..beaf2d8 --- /dev/null +++ b/postgresql/bin/postgresql-backup @@ -0,0 +1,47 @@ +#!/bin/sh + +# Open Infrastructure: service-tools + +# Copyright (C) 2014-2022 Daniel Baumann +# +# 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 . + +set -e + + +#!/bin/sh + +set -e + +DIRECTORY="/srv/$(cat /etc/hostname)/postgresql-backup/$(date +%Y-%m-%d)" +DATABASES="fbm_test" + +mkdir -p "${DIRECTORY}" +chown -R postgres:postgres "${DIRECTORY}" + +for DATABASE in ${DATABASES} +do + su - postgres -c "pg_dump -f ${DIRECTORY} -F d -j $(nproc) -C -d ${DATABASE}" +done + +chown -R root:root "${DIRECTORY}" + + + + +# 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 -- cgit v1.2.3