Re: Help with restoring database from old version of PostgreSQL - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Help with restoring database from old version of PostgreSQL
Date
Msg-id 1f9bc817-8a8d-4ff7-bf66-41a9e882da1a@aklaver.com
Whole thread Raw
In response to Help with restoring database from old version of PostgreSQL  (Catherine Frock <frock@uwalumni.com>)
List pgsql-general
On 11/19/24 14:13, Catherine Frock wrote:
> Do you know what versions of PG and pgAdmin4 I need? Also, I don't know 
> where to get a different version of PG.
> 

You need to take a step back and take stock of where you started and 
where you want to be.

To that end answer the following:

1) What are the Postgres and PostGIS versions you started with?

2) What database or databases do you want to move forward?

3) Is there a hard requirement for what currently supported version of 
Postgres you want to use?

4) What do you want to do with the new install?

5) What versions of Postgres, pgAdmin4 and PostGIS do you currently have 
installed?

6) You are looking at jumping a minimum of 4 major Postgres versions up 
to a maximum of 8 versions. You are also jumping some number of PostGIS 
versions as well. In either case you should at some point go over the 
release notes for each major version jump to see if anything is going to 
cause issues.

> --
> Arden
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Koen De Groote
Date:
Subject: Running docker in postgres, SHM size of the docker container in postgres 16
Next
From: Thomas Munro
Date:
Subject: Re: Running docker in postgres, SHM size of the docker container in postgres 16