| From: | "Chris Henderson" <henders254(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | review db dump script and difference between pg_dump & pg_dumpall |
| Date: | 2008-10-09 03:29:30 |
| Message-ID: | d4ee74cf0810082029u4b0616a1k5c9a24ebd0a3acc1@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have written the following script to backup _all_ databases on
various servers that are running postgresql. I don't want anything
fancy - just be able to backup the database and restore when bad times
come. Just posting it here to be reviewed to see if I have made any
mistake:
#!/bin/bash
DIR=/backup
[ ! $DIR ] && mkdir -p $DIR || :
# ignore any name starting with ---, List, Name, ( or template 0 and 1
LIST=$(psql -l | awk '{ print $1}' | grep -vE
'^-|^List|^Name|^\(|template[0|1]')
for d in $LIST
do
pg_dump $d | gzip -c > $DIR/$d.out.postgres.`hostname`.gz
done
Also, I have read the respective manpages but never understood the
difference between pg_dump & pg_dumpall. But I noticed pg_dumpall
dumps the schema (?) and pg_dump dumps the actual tables and rows etc.
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2008-10-09 07:24:08 | Re: review db dump script and difference between pg_dump & pg_dumpall |
| Previous Message | Andrus | 2008-10-08 20:35:50 | left join conditon causes error |