On Mon, 2007-10-08 at 17:34 -0700, Ralph Smith wrote: > What is the best way to upgrade? Use pg_dumpall (using 8.2's > program), afterwards redirect that file into v8.2 via psql v8.2?
There are lots of ways to do this. My favorite is to bring a new cluster on port 5433 and then pipe data between them, roughly like this: $ /path/to/7.4/pg_dumpall -p5432 ... | /path/to/8.2/psql -p5433 -qaf- >restore.log 2>&1 This obviates the intermediate dump file, which can be large. As a precaution, I remove the PATH elements that locate pg (thus requiring that I specify the full path) and I unsetl PG* variables. -Reece -- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
