MIME-Version: 1.0
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> <1f9bc817-8a8d-4ff7-bf66-41a9e882da1a@aklaver.com>
In-Reply-To: <1f9bc817-8a8d-4ff7-bf66-41a9e882da1a@aklaver.com>
From: Catherine Frock <frock@uwalumni.com>
Date: Wed, 20 Nov 2024 09:23:39 -0500
Message-ID: <CAAkgG6jRb4KzdyBhQ8MJZh0sOLh1jOM88v6BE05ku6hHrQPYxg@mail.gmail.com>
Subject: Re: Help with restoring database from old version of PostgreSQL
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002c471b062758e6a9"
Archived-At: <https://www.postgresql.org/message-id/CAAkgG6jRb4KzdyBhQ8MJZh0sOLh1jOM88v6BE05ku6hHrQPYxg%40mail.gmail.com>
Precedence: bulk

--0000000000002c471b062758e6a9
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.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.klaver@aklaver.com
>
>

--0000000000002c471b062758e6a9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Adrian: Yes, db_2017 is the name I originally=C2=
=A0gave the database in the PostgreSQL 9.6 server. I can&#39;t remember if =
I used pg_dump or pg_dumpall.<br><br>Ron: Okay, I think it finally worked!<=
br><br>Thank you both for your help.<br><br>--</div><div>Arden</div></div><=
br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_att=
r">On Tue, Nov 19, 2024 at 6:00=E2=80=AFPM Adrian Klaver &lt;<a href=3D"mai=
lto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt; wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex">On 11/19/24 14:13, =
Catherine Frock wrote:<br>
&gt; Do you know what versions of PG and pgAdmin4 I need? Also, I don&#39;t=
 know <br>
&gt; where to get a different version of PG.<br>
&gt; <br>
<br>
You need to take a step back and take stock of where you started and <br>
where you want to be.<br>
<br>
To that end answer the following:<br>
<br>
1) What are the Postgres and PostGIS versions you started with?<br>
<br>
2) What database or databases do you want to move forward?<br>
<br>
3) Is there a hard requirement for what currently supported version of <br>
Postgres you want to use?<br>
<br>
4) What do you want to do with the new install?<br>
<br>
5) What versions of Postgres, pgAdmin4 and PostGIS do you currently have <b=
r>
installed?<br>
<br>
6) You are looking at jumping a minimum of 4 major Postgres versions up <br=
>
to a maximum of 8 versions. You are also jumping some number of PostGIS <br=
>
versions as well. In either case you should at some point go over the <br>
release notes for each major version jump to see if anything is going to <b=
r>
cause issues.<br>
<br>
&gt; --<br>
&gt; Arden<br>
&gt; <br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div>

--0000000000002c471b062758e6a9--