public inbox for [email protected]
help / color / mirror / Atom feedFrom: Catherine Frock <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Ron Johnson <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Help with restoring database from old version of PostgreSQL
Date: Wed, 20 Nov 2024 09:23:39 -0500
Message-ID: <CAAkgG6jRb4KzdyBhQ8MJZh0sOLh1jOM88v6BE05ku6hHrQPYxg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAAkgG6hSWMwUUivGzoi_ku6JNXmTVXC2mP7XY5Xs+QPnvKjAdQ@mail.gmail.com>
<[email protected]>
<CAAkgG6jLBV81cN7ogJF0bHj3ymFJ87ULmbnuX=De2rndoTGNXw@mail.gmail.com>
<[email protected]>
<CAAkgG6iWGvmczXnarYTU2PNAWiF3o0DFa47Qzb7M6wjcasNrJQ@mail.gmail.com>
<CANzqJaAO7-FO0Gr=q-mtp=1J360MkPZrO_jKsrWqq41d-upGyw@mail.gmail.com>
<CAAkgG6iq2cjJMifBr1qShb0TkNzDx3kMXyQV4djTSZMa_npTPw@mail.gmail.com>
<[email protected]>
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 <[email protected]>
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
> [email protected]
>
>
view thread (11+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Help with restoring database from old version of PostgreSQL
In-Reply-To: <CAAkgG6jRb4KzdyBhQ8MJZh0sOLh1jOM88v6BE05ku6hHrQPYxg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox