MIME-Version: 1.0
From: Catherine Frock <frock@uwalumni.com>
Date: Wed, 13 Nov 2024 13:50:00 -0500
Message-ID: <CAAkgG6hSWMwUUivGzoi_ku6JNXmTVXC2mP7XY5Xs+QPnvKjAdQ@mail.gmail.com>
Subject: Help with restoring database from old version of PostgreSQL
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c2cedc0626cfcdce"
Archived-At: <https://www.postgresql.org/message-id/CAAkgG6hSWMwUUivGzoi_ku6JNXmTVXC2mP7XY5Xs%2BQPnvKjAdQ%40mail.gmail.com>
Precedence: bulk

--000000000000c2cedc0626cfcdce
Content-Type: text/plain; charset="UTF-8"

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 was
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 the
PostgreSQL/PostGIS installation, but when I try to connect to the
PostgreSQL 16.3 server, I get an internal server error message:
'ServerManager'
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.control": No
such file or directory SQL state: 58P01

How can I restore my database to have access to it again?

Thanks.

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

<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 created with=C2=A0<span style=
=3D"color:rgb(0,0,0);background-color:rgb(254,254,254)">PostgreSQL 9.6. I b=
acked it up successfully and have restored it before, but that was when Pos=
tgreSQL 9.6 was still supported.=C2=A0</span></font><span style=3D"font-fam=
ily:arial,sans-serif;color:rgb(0,0,0);background-color:rgb(254,254,254)">Af=
ter going through the installation of PostgreSQL 16.3, I opened up pgAdmin =
4 to try to verify the PostgreSQL/<span class=3D"gmail-il">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-f=
amily: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;Serve=
rManager&#39; object has no attribute &#39;user_info&#39;.</span></div><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 pgAdmin4, =
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:arial,sans=
-serif">CREATE EXTENSION=C2=A0<span class=3D"gmail-il">postgis</span>;</spa=
n></div><div dir=3D"ltr"><font face=3D"arial, sans-serif">SELECT postgis_ve=
rsion();</font><div><font face=3D"arial, sans-serif">I get the following er=
ror message:=C2=A0=C2=A0ERROR: could not open extension control file &quot;=
C:/Program Files/PostgreSQL/9.6/share/extension/<span class=3D"gmail-il">po=
stgis</span>.control&quot;: No such file or directory SQL state: 58P01<br><=
br>How can I restore my database to have access to it again?<br><br>Thanks.=
</font></div></div></div>

--000000000000c2cedc0626cfcdce--