Re: Upgrading old server - Mailing list pgsql-general

From Christoph Berg
Subject Re: Upgrading old server
Date
Msg-id 20190925142933.GH6888@msg.df7cb.de
Whole thread Raw
In response to Upgrading old server  (Ekaterina Amez <ekaterina.amez@zunibal.com>)
Responses Re: Upgrading old server
List pgsql-general
Re: Ekaterina Amez 2019-09-25 <8818b028-bd2d-412e-d4e3-e29c49ffee17@zunibal.com>
> We've decided to upgrade our PostgreSQL production servers. First task is
> remove an old v7.14 version. It was supposed to be upgraded to a v8.4
> server. The server was installed, several databases where released here but
> v7.4 was never migrated. The plan is pg_dump this database and psql it to
> existing 8.4 server. After this, we'll pg_upgrade.

If you doing dump-restore anyway, why not restore into v11 rightaway?

Christoph



pgsql-general by date:

Previous
From: Krishnakant Mane
Date:
Subject: Re: managing primary key conflicts while restoring data to table withexisting data
Next
From: Tom Lane
Date:
Subject: Re: Mapping view columns to their source columns