Backup of postgres
От
Przemyslaw Bak
Тема
Backup of postgres
Дата
Msg-id
Pine.SV4.3.96.980819104011.19277A-100000@STORE3
Список
Дерево обсуждения
Backup of postgres Przemyslaw Bak <przemol@st3.makro.com.pl>
Re: [ADMIN] Backup of postgres Marc Howard Zuckman <marc@fallon.classyad.com>
Re: [ADMIN] Backup of postgres Przemyslaw Bak <przemol@st3.makro.com.pl>
Hi all, I have following script to backup database: --------- cut ---------- #!/bin/sh PSQL=/usr/local/pgsql/bin/psql DUMP=/usr/local/pgsql/bin/pg_dump PREFIX=`date +%j` BACKUP_DIR=/usr/local/pgsql/data/base/.BACKUP Databases=`$PSQL -tq -d template1 -c "select datname from pg_database"` renice 20 $$ echo Backup started ... for db in `echo $Databases` do echo "time: `date +%H%M%S` - Backup of $db in progress ..." $DUMP -D $db > /$BACKUP_DIR/$PREFIX.$db echo "time: `date +%H%M%S` - Backup of $db finnished ..." done echo Backup finnished ... --------- cut ---------- Crontab runs it every night (4:00am - nobody is working on the machine). But every run I have following message: ---------- cut ------------- From: Cron Daemon To: postgres@shire.st3.makro.com.pl Subject: Cron /usr/local/pgsql/store3/Backup.sh 3986: old priority 0, new priority 20 Backup started ... time: 040001 - Backup of template1 in progress ... time: 040004 - Backup of template1 finnished ... time: 040004 - Backup of mzo in progress ... time: 040010 - Backup of mzo finnished ... time: 040010 - Backup of store3 in progress ... /usr/local/pgsql/store3/Backup.sh: line 19: 4002 Segmentation fault $DUMP -D $db >/$BACKUP_DIR/$PREFIX.$db time: 042021 - Backup of store3 finnished ... Backup finnished ... ---------- cut ------------- What's wrong with this script ? It is running on Linux 2.0.33, Pentium 200, 64MB. Please help - we save in postgres huge number of data. przemol
В списке pgsql-general по дате отправления