Search Postgresql Archives

Re: Multiple versions on same box

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux