MIME-Version: 1.0
References: <CAAkgG6hSWMwUUivGzoi_ku6JNXmTVXC2mP7XY5Xs+QPnvKjAdQ@mail.gmail.com>
In-Reply-To: <CAAkgG6hSWMwUUivGzoi_ku6JNXmTVXC2mP7XY5Xs+QPnvKjAdQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 13 Nov 2024 14:47:22 -0500
Message-ID: <CANzqJaCHsrrmCkg0xPP_mpi=cZJ4Nbty+ihU2yUa12Mj9+Ww5g@mail.gmail.com>
Subject: Re: Help with restoring database from old version of PostgreSQL
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d6dfd50626d09a92"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCHsrrmCkg0xPP_mpi%3DcZJ4Nbty%2BihU2yUa12Mj9%2BWw5g%40mail.gmail.com>
Precedence: bulk

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

On Wed, Nov 13, 2024 at 1:50=E2=80=AFPM Catherine Frock <frock@uwalumni.com=
> wrote:

> I'm seeking help in restoring a database that was created with PostgreSQL
> 9.6. I backed it up successfully and have restored it before, but that wa=
s
> when PostgreSQL 9.6 was still supported. After going through the
> installation of PostgreSQL 16.3, I opened up pgAdmin 4 to try to verify t=
he
> PostgreSQL/PostGIS installation, but when I try to connect to the
> PostgreSQL 16.3 server, I get an internal server error message:   'Server=
Manager'
> object has no attribute 'user_info'.
>
> In pgAdmin4, I am able to connect to the PostgreSQL 9.6 server, but when =
I
> try to verify the install by querying: CREATE EXTENSION postgis;
> SELECT postgis_version();
> I get the following error message:  ERROR: could not open extension
> control file "C:/Program Files/PostgreSQL/9.6/share/extension/postgis.con=
trol":
> No such file or directory SQL state: 58P01
>
> How can I restore my database to have access to it again?
>

Do you still have the backup file somewhere?  If so, then modern versions
of PG *will* read the 9.6 backup file.  You "just" need to have PostGIS
somewhere on disk that PG 16.3 knows about.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Nov 13, 2024 at 1:50=E2=80=AFPM C=
atherine Frock &lt;<a href=3D"mailto:frock@uwalumni.com">frock@uwalumni.com=
</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><font face=3D"=
arial, sans-serif">I&#39;m seeking help in restoring a database that was cr=
eated with=C2=A0<span style=3D"color:rgb(0,0,0);background-color:rgb(254,25=
4,254)">PostgreSQL 9.6. I backed it up successfully and have restored it be=
fore, but that was when PostgreSQL 9.6 was still supported.=C2=A0</span></f=
ont><span style=3D"font-family:arial,sans-serif;color:rgb(0,0,0);background=
-color:rgb(254,254,254)">After going through the installation of PostgreSQL=
 16.3, I opened up pgAdmin 4 to try to verify the PostgreSQL/<span>PostGIS<=
/span>=C2=A0installation, but when I try to connect to the PostgreSQL 16.3 =
server, I get an internal server error message:=C2=A0</span><span style=3D"=
font-family:arial,sans-serif">=C2=A0</span><span style=3D"font-family:arial=
,sans-serif">=C2=A0</span><span style=3D"font-family:arial,sans-serif">&#39=
;ServerManager&#39; object has no attribute &#39;user_info&#39;.</span></di=
v><div dir=3D"ltr"><span style=3D"font-family:arial,sans-serif"><br></span>=
</div><div dir=3D"ltr"><span style=3D"font-family:arial,sans-serif">In pgAd=
min4, I am able to connect to the PostgreSQL 9.6 server, but when I try to =
verify the install by querying:=C2=A0</span><span style=3D"font-family:aria=
l,sans-serif">CREATE EXTENSION=C2=A0<span>postgis</span>;</span></div><div =
dir=3D"ltr"><font face=3D"arial, sans-serif">SELECT postgis_version();</fon=
t><div><font face=3D"arial, sans-serif">I get the following error message:=
=C2=A0=C2=A0ERROR: could not open extension control file &quot;C:/Program F=
iles/PostgreSQL/9.6/share/extension/<span>postgis</span>.control&quot;: No =
such file or directory SQL state: 58P01<br><br>How can I restore my databas=
e to have access to it again?<br></font></div></div></div></blockquote><div=
><br></div><div>Do you still have the backup file somewhere?=C2=A0 If so, t=
hen modern versions of PG <i>will</i>=C2=A0read the 9.6 backup file.=C2=A0 =
You &quot;just&quot; need to have PostGIS somewhere on disk that PG 16.3 kn=
ows about.</div></div><div><br></div><span class=3D"gmail_signature_prefix"=
>-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">=
Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m=
 still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div=
></div></div>

--000000000000d6dfd50626d09a92--