Re: Help with restoring database from old version of PostgreSQL

Adrian: Yes, db_2017 is the name I originally gave the database in the
PostgreSQL 9.6 server. I can't remember if I used pg_dump or pg_dumpall.

Ron: Okay, I think it finally worked!

Thank you both for your help.

--
Arden

On Tue, Nov 19, 2024 at 6:00 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

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