Re: Help with restoring database from old version of PostgreSQL

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(dot)klaver(at)aklaver(dot)com