From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Upgrading old server |
Date: | 2019-09-25 15:37:36 |
Message-ID: | be9eef56-243f-6493-5f1e-7fffdc334cde@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 9/25/19 9:29 AM, Christoph Berg wrote:
> Re: Ekaterina Amez 2019-09-25 <8818b028-bd2d-412e-d4e3-e29c49ffee17(at)zunibal(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sonam Sharma | 2019-09-25 15:55:09 | Re: Pg_auto_failover |
Previous Message | David G. Johnston | 2019-09-25 15:36:23 | Re: Receivgin error while altering the table column datatype |