Re: Upgrading Database: need to dump and restore?

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.