Feedback-ID: i76984098:Fastmail
Message-ID: <1f9bc817-8a8d-4ff7-bf66-41a9e882da1a@aklaver.com>
Date: Tue, 19 Nov 2024 15:00:05 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Help with restoring database from old version of PostgreSQL
To: Catherine Frock <frock@uwalumni.com>,
 Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAAkgG6hSWMwUUivGzoi_ku6JNXmTVXC2mP7XY5Xs+QPnvKjAdQ@mail.gmail.com>
 <1fe9de96-6ebe-4e3a-9b15-ae8a11986664@aklaver.com>
 <CAAkgG6jLBV81cN7ogJF0bHj3ymFJ87ULmbnuX=De2rndoTGNXw@mail.gmail.com>
 <11b5cfbd-cb44-4bc5-b74e-c6c682d9cfb9@aklaver.com>
 <CAAkgG6iWGvmczXnarYTU2PNAWiF3o0DFa47Qzb7M6wjcasNrJQ@mail.gmail.com>
 <CANzqJaAO7-FO0Gr=q-mtp=1J360MkPZrO_jKsrWqq41d-upGyw@mail.gmail.com>
 <CAAkgG6iq2cjJMifBr1qShb0TkNzDx3kMXyQV4djTSZMa_npTPw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAAkgG6iq2cjJMifBr1qShb0TkNzDx3kMXyQV4djTSZMa_npTPw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/1f9bc817-8a8d-4ff7-bf66-41a9e882da1a%40aklaver.com>
Precedence: bulk

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