scripts/pgbackup
author Tomas Zeman <tomas@functionals.cz>
Thu, 19 Feb 2026 10:37:57 +0100
changeset 62 9444c538bb93
parent 23 5eaf174f21fa
permissions -rw-r--r--
screenrc: updated green color (a little bit darker)
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
23
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     1
#!/bin/sh -e
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     2
# Creates full pgsql backup with symlinks to last and prev backup.
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     3
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     4
BACKUPDIR=/home/pgsql/backup
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     5
N=pg_dumpall-`date +%F`.bz2
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     6
F=$BACKUPDIR/$N
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     7
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     8
pg_dumpall | bzip2 > $F.tmp
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
     9
mv $F.tmp $F
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    10
cd $BACKUPDIR
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    11
[ -L last ] && mv last prev
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    12
ln -sf $N last
5eaf174f21fa scripts/pgbackup
Tomas Zeman <tzeman@volny.cz>
parents:
diff changeset
    13