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 по дате отправления
От: Os Tyler
Дата:
Сообщение: sequences/operators
От: Herouth Maoz
Дата:
Сообщение: pg-dump problem
FAQ