Re: Best practice for 8.1.5 -> 8.2 migration - with big database? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Best practice for 8.1.5 -> 8.2 migration - with big database?
Date
Msg-id 200702142113.11307.peter_e@gmx.net
Whole thread Raw
In response to Best practice for 8.1.5 -> 8.2 migration - with big database?  ("Mason Hale" <masonhale@gmail.com>)
List pgsql-general
Mason Hale wrote:
> So, I'm fishing to see of there are alternatives to taking our
> production database down for 6+ hours do this upgrade. Can slony or
> wal files be of help here?

Slony can, but WAL files will not work between different versions.

> Also -- due to hardware limitations, we need to install 8.2.x on the
> same hardware 8.1.5 is currently running on. Can those two versions
> exist side-by-side?

Sure.  Just set a different port and different data directory.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Protect PL/PGSQL source
Next
From: Ron Johnson
Date:
Subject: Re: backup database by cloning itself