On Tue, May 22, 2001 at 10:36:46AM +1000, Brian May wrote: > >>>>> "Petr" == Petr Cech <cech@atrey.karlin.mff.cuni.cz> writes: > > Petr> yes. dump. purge. install. reload - there are IMHO way too > Petr> much possible configurations to can safely do this > Petr> automaticaly. And that's what is the .deb also trying to do > Petr> - automaticaly. So do it by hand and you're OK. > > How do you dump a 7.0 database? I keep getting memory errors generated > by the old server all the time. (maybe I am not starting it correctly? > It is the copy stored in /var/lib/postgresql/dumpall/7.0/) I've attached the backup script I use to do dumps, which works mostly because I only have a few different users that actually need postgres access (my method would become a major nuisance with more than half a dozen or so). I do restores manually. The script has been tested on 7.0 and 7.1 (the grep -v template0 is a 7.1 specific thing I added), and should work on pretty much any older version, though I do miss pg_dumpall. > How do you import the new database into 7.1? I tried psql, but > without success. Will try it again when I know the answers to the > above (at least the 2nd one). su to postgres first, then recreate accounts for all the users that you had before (if someone knows a decent way to do this automatically, please let me know). Set your pg_hba.conf to blind trust mode. Do a createdb -U <username> <database> for each database. Do psql -f <dumpfile> <database> for each dump. -- Zed Pobre <zed@debian.org> a.k.a. Zed Pobre <zed@resonant.org> PGP key and fingerprint available on finger; encrypted mail welcomed.
#!/bin/sh # for a in `/usr/bin/psql template1 -l -t | grep -v template0 | /usr/bin/cut -d ' ' -f 2` ; do rm -f data_backup-$a-`/bin/date +%Y%m%d` pg_dump $a >> data_backup-$a-`/bin/date +%Y%m%d` done
Attachment:
pgpBzpkrE2_TJ.pgp
Description: PGP signature