| 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 |