From: | Przemyslaw Bak <przemol(at)st3(dot)makro(dot)com(dot)pl> |
---|---|
To: | Marc Howard Zuckman <marc(at)fallon(dot)classyad(dot)com> |
Cc: | pgsql-admin(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [ADMIN] Backup of postgres |
Date: | 1998-08-21 13:35:30 |
Message-ID: | Pine.SV4.3.96.980821153433.26232A-100000@STORE3 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On Wed, 19 Aug 1998, Marc Howard Zuckman wrote:
>
> On Wed, 19 Aug 1998, Przemyslaw Bak wrote:
>
> > 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 <root(at)shire(dot)st3(dot)makro(dot)com(dot)pl>
> > To: postgres(at)shire(dot)st3(dot)makro(dot)com(dot)pl
> > Subject: Cron <postgres(at)shire> /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
> >
> >
> What version of postgresql are you running? I can't recall whether
> it was in 6.2 or 6.1 (I think 6.2), but one of those versions
> contained a pg_dump that would seg fault on some databases.
Postgres 6.3.2. I compiled it from sources.
przemol
From | Date | Subject | |
---|---|---|---|
Next Message | roland.wild | 1998-08-21 16:06:52 | Quistion on PostgreSQL ! |
Previous Message | Brook Milligan | 1998-08-20 18:08:14 | groups? |
From | Date | Subject | |
---|---|---|---|
Next Message | Sferacarta Software | 1998-08-21 16:00:23 | DELETE statement KILL backend <AGAIN> |
Previous Message | Andrew Gibson | 1998-08-21 13:19:55 | Listing viewing triggers |