Warning: Undefined array key "rss_show_deleted" in /var/www/w12/dw/inc/Feed/FeedCreatorOptions.php on line 86
Warning: Cannot modify header information - headers already sent by (output started at /var/www/w12/dw/inc/Feed/FeedCreatorOptions.php:86) in /var/www/w12/dw/feed.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /var/www/w12/dw/inc/Feed/FeedCreatorOptions.php:86) in /var/www/w12/dw/feed.php on line 54
Warning: Cannot modify header information - headers already sent by (output started at /var/www/w12/dw/inc/Feed/FeedCreatorOptions.php:86) in /var/www/w12/dw/feed.php on line 55
Warning: Cannot modify header information - headers already sent by (output started at /var/www/w12/dw/inc/Feed/FeedCreatorOptions.php:86) in /var/www/w12/dw/feed.php on line 56
Warning: Cannot modify header information - headers already sent by (output started at /var/www/w12/dw/inc/Feed/FeedCreatorOptions.php:86) in /var/www/w12/dw/inc/httputils.php on line 32
Warning: Cannot modify header information - headers already sent by (output started at /var/www/w12/dw/inc/Feed/FeedCreatorOptions.php:86) in /var/www/w12/dw/inc/httputils.php on line 33 wi12.unix7.org - pg
https://w12.unix7.org/
Wed, 05 Aug 2026 06:20:31 +0000FeedCreator 1.8https://w12.unix7.org/_media/wiki/dokuwiki.svgwi12.unix7.org
https://w12.unix7.org/
Tools for dumping PgDB with purge old files
https://w12.unix7.org/pg/lpgdump
Tools for dumping PgDB with purge old files
#!/bin/sh
#
# $Id$
#
dblist="db1 db2 db3"
pghost="pg-host.domain.org"
pgpass="pgpassword"
pguser="pguser"
tz="KGD"
count=4
dstdir="/data/store"
for db in $dblist;do
mkdir -p $dstdir
timestamp=$(date +%Y%m%d-%H%M)
PGPASSWORD=$pgpass
export PGPASSWORD
pg_dump -h $pghost -U $pguser -Fc -f $dstdir/$db--$timestamp-$tz--$pghost.sqlz $db
find $dstdir/ | grep "$db" | sort -Vr | tail -n "+$count" | xargs -n1 rm -f
done
#EOFanonymous@undisclosed.example.com (Anonymous)Sat, 27 Nov 2021 13:26:11 +0000