You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
585 B
18 lines
585 B
5 years ago
|
#!/bin/sh
|
||
|
|
|
||
|
3 years ago
|
set -eo pipefail
|
||
|
5 years ago
|
|
||
|
|
DEST=/home/lbkp/bm/pgsql
|
||
|
|
mkdir -p $DEST
|
||
|
|
chown postgres:postgres $DEST
|
||
|
|
chmod 700 $DEST
|
||
|
|
|
||
|
|
for DB in $(su - postgres -c "/bin/psql -d postgres -qtc 'SELECT datname from pg_database' | grep -vP '^\s+?template[01]$'")
|
||
|
|
do
|
||
|
3 years ago
|
su - postgres -c "/bin/pg_dump -Fp -Cc $DB" | /bin/nice -n 10 zstd -c > $DEST/$DB.sql.zst
|
||
|
5 years ago
|
done
|
||
|
3 years ago
|
su - postgres -c "/bin/pg_dumpall --globals-only" | /bin/nice -n 10 zstd -c > $DEST/pg_globals.sql.zst
|
||
|
|
su - postgres -c "/bin/pg_dumpall --schema-only" | /bin/nice -n 10 zstd -c > $DEST/pg_schema.sql.zst
|
||
|
5 years ago
|
|
||
|
|
cp -a /etc/bm/local /home/lbkp/bm/conf
|