Re: Upgrading old server

On 9/25/19 9:00 AM, Tom Lane wrote:
> Ron <ronljohnsonjr@gmail.com> writes:
>> 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.
> 
> We dropped support for pre-8.0 source servers in pg_dump sometime
> recently, though I forget if v11 is affected by that or not.

Version 10.0:

https://www.postgresql.org/docs/10/release-10.html


> You could try just dumping with 7.4's pg_dump and seeing if the
> output will load into v11 --- ideally it would, but I'd not be
> surprised if there are issues that have to be resolved manually.
> Or, if you have 8.4's pg_dump at hand, try using that.
> 
> 7.4 to 11 is a big jump to be doing in one step.  There's definitely
> something to be said for porting to an intermediate release, just to
> break down the work into smaller chunks.  But I'd go for halfway between,
> which if I counted releases correctly would be about 9.1, not 8.4.
> 
>             regards, tom lane
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com