Re: Upgrading old server

From: Christoph Berg <myon(at)debian(dot)org>
To: Ekaterina Amez <ekaterina(dot)amez(at)zunibal(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Upgrading old server
Date: 2019-09-25 14:29:33
Message-ID: 20190925142933.GH6888@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Christoph

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-09-25 14:39:18 Re: Mapping view columns to their source columns
Previous Message Krishnakant Mane 2019-09-25 14:24:07 Re: managing primary key conflicts while restoring data to table with existing data