Re: Upgrading old server - Mailing list pgsql-general

From Ron
Subject Re: Upgrading old server
Date
Msg-id be9eef56-243f-6493-5f1e-7fffdc334cde@gmail.com
Whole thread Raw
In response to Re: Upgrading old server  (Christoph Berg <myon@debian.org>)
Responses Re: Upgrading old server
List pgsql-general
On 9/25/19 9:29 AM, Christoph Berg wrote:
> 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?

Since it's recommend to run the newer pg_dump on the older database, I've 
got to wonder if v11 pg_dump can read the v7.4 on-disk structures.

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Receivgin error while altering the table column datatype
Next
From: Sonam Sharma
Date:
Subject: Re: Pg_auto_failover