Postgres Pro
Downloads
Home   >   mailing lists

Thread: Multiple versions on same box

Multiple versions on same box

From
Ralph Smith
Date:
Hello,

For upgrade purposes I now have 7.4 and 8.2 on the same Ubuntu box, and that brings up some questions that I know of, and I'm sure many that I haven't thought of yet.

I assume that I'll have to put the full path to the version of psql, etc, corresponding to the same version database that I want to access.

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?

Many thanks!
Ralph Smith
=====================


Re: Multiple versions on same box

From
Reece Hart
Date:
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

Re: Multiple versions on same box

From
"Scott Marlowe"
Date:
On 10/9/07, Reece Hart <reece@harts.net> wrote:
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

Note that when possible you should dump with the pg_dump/pg_dumpall of the version you're going to, in this case 8.2's pg_dumpall