Re: Upgrading Database: need to dump and restore? - Mailing list pgsql-general

From Jasen Betts
Subject Re: Upgrading Database: need to dump and restore?
Date
Msg-id h0isn2$bu8$3@reversiblemaps.ath.cx
Whole thread Raw
In response to Upgrading Database: need to dump and restore?  ("Carlos Oliva" <carlos@pbsinet.com>)
List pgsql-general
On 2009-06-03, Carlos Oliva <carlos@pbsinet.com> wrote:
> Woudl it be possible to keep the current postgresql version running in a
> different port, install a new version of postgresql, and copy the data from
> one version to the other while both versions are running?  This might give
> us time to copy the tables and databases one at a time and reconfigure the
> database access for parts of the application until we complete the migration
> to the new version.

Yes that's possible. The debian packaged versions since 8.0 are
designed to facilitate multiple clusters on a single host, and if you
install two major versions of postgres it'll automatically set them up
for you using port 5433 for the new version.

On redhat it may not be so easy.



pgsql-general by date:

Previous
From: "Grand, Mark D."
Date:
Subject: Re: invalid byte sequence for encoding "UTF8": 0xab
Next
From: Dimitri Fontaine
Date:
Subject: Re: PL/PGSQL