Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDW4o-001G5w-0T for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2024 21:48:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tDW4l-00HLlz-OA for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2024 21:47:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDW4k-00HLld-Rh for pgsql-general@lists.postgresql.org; Tue, 19 Nov 2024 21:47:59 +0000 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tDW4g-002lMH-A4 for pgsql-general@lists.postgresql.org; Tue, 19 Nov 2024 21:47:56 +0000 Received: by mail-yb1-xb2c.google.com with SMTP id 3f1490d57ef6-e3890093c13so1363282276.1 for ; Tue, 19 Nov 2024 13:47:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=uwalumni.com; s=google; t=1732052873; x=1732657673; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=xdSnTcecHGrskPb40+dcEDbfIs5ccXTtYPaffMoOK4w=; b=TtTsCdkNhoyFPDnf1i/IVSGWAZQwEUag97YIfmPngqnescq03sIx33IxoIlWMed+KY N0NGiV1zA4bHgTeNF69gvnkcYiLRUbHah2IvszFwAfy3pHPbnGxMdb86XnYpHoRnYkpC E64YypLEFb8eq0Ouoh+Id67jji5yRlpqxy+jc= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732052873; x=1732657673; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=xdSnTcecHGrskPb40+dcEDbfIs5ccXTtYPaffMoOK4w=; b=uJJ/efeMXR08bNclAexMK7rXGTqacQHd1ak7gVwlYqWh+FQIo5f8M0kTcWWhACMEWU lMMo37qv9P3pbRMriDQlOV2Y3IxRHodCgS8JKQIedFTs6ObmqDwFAY590nG13Z7tXYPC fyKnOC+hNZpoIq2jZgejCdI4bB3W+0/KXw9ksrakksikR4fUEk1rITfWaZK+JCKjkqal +EEuDBJMYdDO4ZA45b8Mech/8N4db5mD3TGJ/tt1CTvIKx7DwB6y8obM6B4rrYVATGCL zJWjYx/EztrzhY4Co3fk4B+2q+BEou8d1pmxcnx9PCiNmLDnWtZI5+5Xmrpr+YD5rHdl cwNw== X-Forwarded-Encrypted: i=1; AJvYcCXx0CWGw+NLvhvHYAzv72neLtbgfdM0hP3ZebTvdMopb6mEqScqWcBi6g47HF2XxhO1Q0SPSkBWMGxKll8n@lists.postgresql.org X-Gm-Message-State: AOJu0Yzx1vWgnviTZiJoqB6agIkGPLDJ5G1G978V3kABG1PE3ue3mpfV ZhTtXp1RnT5wY3iVmkKy26Qeo0boozhb6yTWBfc8IusIwgBDdenmiL37H9GUukxIyr9ohwfjInv tsKw448TwurUOxU0Lq4oVTnxnhf37Z1TX0NWqDw== X-Google-Smtp-Source: AGHT+IHXdKWdx/m+xVZT9BVtulsq6+pJuQCjNgN0X3UdvUqAdBmjiNjr1aeaq8gZTklNUIRDZxAhp0OlhTwvFkDQP48= X-Received: by 2002:a05:6902:100b:b0:e30:cc34:af1a with SMTP id 3f1490d57ef6-e38cb5f6fa8mr269221276.35.1732052873393; Tue, 19 Nov 2024 13:47:53 -0800 (PST) MIME-Version: 1.0 References: <1fe9de96-6ebe-4e3a-9b15-ae8a11986664@aklaver.com> <11b5cfbd-cb44-4bc5-b74e-c6c682d9cfb9@aklaver.com> In-Reply-To: <11b5cfbd-cb44-4bc5-b74e-c6c682d9cfb9@aklaver.com> From: Catherine Frock Date: Tue, 19 Nov 2024 16:47:40 -0500 Message-ID: Subject: Re: Help with restoring database from old version of PostgreSQL To: Adrian Klaver Cc: ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000040569506274afc62" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000040569506274afc62 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I am trying to restore a previously backed up database .sql file that was created in PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was using). In response to Ron: Do I need to use PG16 instead of pgAdmin4? And if so, can you please provide a website where I can download PG16? In response to Adrian: How do I determine what version of PostGIS I need to be using? When I installed it, I was only given one option of a version to install. Since my previous installation of pgAdmin4 was not working, I have started over today, uninstalling all versions of PostgreSQL that I had and reinstalling PostgreSQL Version 17.0 from https://www.enterprisedb.com/ and pgAdmin4 version 8.12 from https://www.pgadmin.org. I tried installing PostgreSQL 9.6.24 also, but I received an error message when I run the installation file: "An error occurred executing the Microsoft VC++ runtime installer." I installed the latest versions of the PostGIS (3.5.0) and psqlODBC drivers (I'm forgot to write that down and am not sure how to check the version). My installation of PostgreSQL/PostGIS was verified as successful. I am able to connect to the PostgreSQL 9.6 and 17 servers. I set the PostgreSQL Binary Path to: C:\Program Files\PostgreSQL\17\bin. I have tried to restore my database using this in the command prompt: "psql.e= xe db_2024_9 < C:\postgis\db_2017-08-16.sql postgres" using an empty database in both the PostgreSQL 9.6 and 17 servers, and this is the result: Password for user postgres: SET SET SET SET SET SET SET SET WARNING: database "db_2017" does not exist COMMENT CREATE SCHEMA ALTER SCHEMA COMMENT CREATE SCHEMA ALTER SCHEMA COMMENT CREATE SCHEMA ALTER SCHEMA COMMENT CREATE SCHEMA ALTER SCHEMA COMMENT CREATE EXTENSION COMMENT CREATE EXTENSION COMMENT SET CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT CREATE FUNCTION ALTER FUNCTION COMMENT SET SET SET CREATE TABLE ALTER TABLE COMMENT CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE CREATE TABLE ALTER TABLE COMMENT SET CREATE TABLE ALTER TABLE SET CREATE VIEW ALTER TABLE COMMENT SET CREATE TABLE ALTER TABLE SET CREATE TABLE ALTER TABLE COMMENT SET CREATE VIEW ALTER TABLE COMMENT CREATE VIEW ALTER TABLE COMMENT SET CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE SET CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE CREATE TABLE ALTER TABLE COMMENT CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE CREATE TABLE ALTER TABLE COMMENT CREATE TABLE ALTER TABLE CREATE SEQUENCE ALTER TABLE ALTER SEQUENCE SET CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE SET ALTER TABLE SET ALTER TABLE ALTER TABLE ALTER TABLE SET COPY 0 setval -------- 1 (1 row) COPY 0 SET COPY 3 COPY 7 COPY 6 COPY 3 SET COPY 67 COPY 37649 setval -------- 38344 (1 row) COPY 38783 COPY 38344 setval -------- 41058 (1 row) COPY 81 COPY 81 setval -------- 654 (1 row) SET COPY 35 COPY 40 COPY 39 COPY 35 COPY 35 COPY 0 COPY 58 COPY 39 SET ALTER TABLE SET ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE SET ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE TRIGGER CREATE TRIGGER CREATE TRIGGER COMMENT CREATE TRIGGER ALTER TABLE ALTER TABLE ALTER TABLE ERROR: role "basic_user" does not exist ERROR: role "basic_user" does not exist ERROR: role "basic_user" does not exist ERROR: role "basic_user" does not exist SET ERROR: role "basic_user" does not exist ERROR: role "basic_user" does not exist SET ERROR: role "basic_user" does not exist SET ERROR: role "basic_user" does not exist SET ERROR: role "basic_user" does not exist SET ERROR: role "basic_user" does not exist ERROR: role "basic_user" does not exist SET ERROR: role "basic_user" does not exist SET ERROR: role "basic_user" does not exist ERROR: role "basic_user" does not exist ERROR: role "basic_user" does not exist ERROR: role "basic_user" does not exist SET ALTER DEFAULT PRIVILEGES ERROR: role "basic_user" does not exist SET ALTER DEFAULT PRIVILEGES ERROR: role "basic_user" does not exist SET ALTER DEFAULT PRIVILEGES ERROR: role "basic_user" does not exist SET ALTER DEFAULT PRIVILEGES ERROR: role "basic_user" does not exist -- Arden On Thu, Nov 14, 2024 at 12:02=E2=80=AFPM Adrian Klaver wrote: > On 11/14/24 07:00, Catherine Frock wrote: > > Yes, I still have the backup file. I tried to open pgAdmin4 today to se= e > > what version I'm running, and now this happened (see attachments). My > > operating system is Windows 10 Home, version 10.0.19045 Build 19045. I > > installed Postgres using these instructions: > > > https://basille.org/postgis2017/installation_instructions/install_postgre= sql.html > < > https://basille.org/postgis2017/installation_instructions/install_postgre= sql.html> I'm > guessing at this point I probably need to start all over with the > installation since pgAdmin4 is not working? But if 9.6 is no longer > supported, can I still use it to access my database? I assumed I would ne= ed > to migrate to the most recent version of PostgreSQL, but maybe that was a > wrong assumption? > > 1) You can copy/paste the error message and provide as text. > > 2) Assuming you are installing Postgres 16 from the EDB package, the > from here: > > https://www.postgresql.org/download/windows/ > > PostgreSQL Version 64 Bit Windows Platforms > 16 2022, 2019 > > [...] > 11 2019, 2016, 2012 R2 > 10 2016, 2012 R2 & R1, 7, 8, 10 > > 3) From here: > > https://www.enterprisedb.com/downloads/postgres-postgresql-downloads > > 9.6 can still be downloaded. > > It is not a supported version, but you can at least use it to access > your database. > > > 4) You need to provide a more detailed explanation of what you are > trying to achieve. > > 5) 9.6 -> 16 is six major version jump. That means some research needs > to be done, starting with determining what version of PostGIS you need > to be using. > > > > > Thank you for your help, > > -- > > Arden > > > > > > On Wed, Nov 13, 2024 at 3:42=E2=80=AFPM Adrian Klaver > > wrote: > > > > On 11/13/24 10:50, Catherine Frock 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 was when PostgreSQL 9.6 was still supported. After goin= g > > > > Do you still have the Postgres 9.6 instance running? > > > > > through the installation of PostgreSQL 16.3, I opened up pgAdmin > > 4 to > > > > What version of pgAdmin4? > > > > > try to verify the PostgreSQL/PostGIS installation, but when I tr= y > 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 > > > > So the 9.6 instance is running. > > > > > I try to verify the install by querying: CREATE EXTENSION postgi= s; > > > 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 > > > > What OS and version are you running? > > > > How did you install Postgres? > > > > > > > > > > How can I restore my database to have access to it again? > > > > > > Thanks. > > > > -- > > Adrian Klaver > > adrian.klaver@aklaver.com > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > --00000000000040569506274afc62 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I am tryi= ng to restore a previously backed up database .sql file that was created in= PostgreSQL 9.6 using pgAdmin4 (I'm not sure which version I was using)= .

<= /div>
In response to Ron: D= o I need to use PG16 instead of pgAdmin4? And if so, can you please provide= a website where I can download PG16?

In response to Adrian: = How do I determine what version of PostGIS I=C2=A0need to be using? When I = installed it, I was only given one option of a version to install.

Since my previous installation of pgAd= min4 was not working, I have started over today, uninstalling all versions = of PostgreSQL that I had and reinstalling=C2=A0PostgreSQL Version 17.0 from=C2=A0https://www.enterprisedb.com/=C2=A0and pgAdmin4 version=C2=A08.12 from=C2=A0https://www.pgadmin.= org. I tried installing PostgreSQL 9.6.24 also, but I received an error= message when=C2=A0I run the installation file: "An error occurred exe= cuting the Microsoft VC++ runtime installer." I installed the latest v= ersions of the=C2=A0PostGIS (3.5.0) and psqlODBC drivers (I'm forgot to write t= hat down and am not sure how to check the version). My installation of=C2= =A0PostgreSQL/PostGIS was verified as successful. I am able to connect to = the PostgreSQL 9.6 and 17 servers. I set the=C2=A0PostgreSQL Binary Path to:=C2=A0C:\Program Files\PostgreSQL\17\bin. I have tried to restore my database using this in = the command prompt: "psql.exe db_2024_9 < C:\postgis\db_2017= -08-16.sql postgres" using an empty database in both the PostgreSQL 9.= 6 and 17 servers, and this is the result:

Password for user postgres= :
SET
SET
SET
SET
SET
SET
SET
SET
WARNING: =C2= =A0database "db_2017" does not exist
COMMENT
CREATE SCHEMA<= br>ALTER SCHEMA
COMMENT
CREATE SCHEMA
ALTER SCHEMA
COMMENT
C= REATE SCHEMA
ALTER SCHEMA
COMMENT
CREATE SCHEMA
ALTER SCHEMACOMMENT
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
S= ET
CREATE FUNCTION
ALTER FUNCTION
COMMENT
CREATE FUNCTION
AL= TER FUNCTION
COMMENT
CREATE FUNCTION
ALTER FUNCTION
COMMENT
= CREATE FUNCTION
ALTER FUNCTION
COMMENT
CREATE FUNCTION
ALTER FU= NCTION
COMMENT
SET
SET
SET
CREATE TABLE
ALTER TABLE
CO= MMENT
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLEALTER TABLE
COMMENT
SET
CREATE TABLE
ALTER TABLE
SET
CR= EATE VIEW
ALTER TABLE
COMMENT
SET
CREATE TABLE
ALTER TABLESET
CREATE TABLE
ALTER TABLE
COMMENT
SET
CREATE VIEW
AL= TER TABLE
COMMENT
CREATE VIEW
ALTER TABLE
COMMENT
SET
CRE= ATE TABLE
ALTER TABLE
COMMENT
CREATE TABLE
ALTER TABLE
CREAT= E TABLE
ALTER TABLE
SET
CREATE TABLE
ALTER TABLE
CREATE SEQU= ENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
COM= MENT
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLEALTER TABLE
COMMENT
CREATE TABLE
ALTER TABLE
CREATE SEQUENCEALTER TABLE
ALTER SEQUENCE
SET
CREATE TABLE
ALTER TABLE
CR= EATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLEALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE<= br>CREATE TABLE
ALTER TABLE
SET
ALTER TABLE
SET
ALTER TABLE<= br>ALTER TABLE
ALTER TABLE
SET
COPY 0
=C2=A0setval
--------<= br>=C2=A0 =C2=A0 =C2=A0 1
(1 row)

COPY 0
SET
COPY 3
COPY= 7
COPY 6
COPY 3
SET
COPY 67
COPY 37649
=C2=A0setval
-= -------
=C2=A0 38344
(1 row)

COPY 38783
COPY 38344
=C2= =A0setval
--------
=C2=A0 41058
(1 row)

COPY 81
COPY 81<= br>=C2=A0setval
--------
=C2=A0 =C2=A0 654
(1 row)

SET
C= OPY 35
COPY 40
COPY 39
COPY 35
COPY 35
COPY 0
COPY 58
= COPY 39
SET
ALTER TABLE
SET
ALTER TABLE
ALTER TABLE
ALTER= TABLE
ALTER TABLE
SET
ALTER TABLE
ALTER TABLE
ALTER TABLEALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDE= X
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
COMMENT
CREAT= E TRIGGER
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: =C2=A0role= "basic_user" does not exist
ERROR: =C2=A0role "basic_use= r" does not exist
ERROR: =C2=A0role "basic_user" does not= exist
ERROR: =C2=A0role "basic_user" does not exist
SETERROR: =C2=A0role "basic_user" does not exist
ERROR: =C2=A0ro= le "basic_user" does not exist
SET
ERROR: =C2=A0role "= basic_user" does not exist
SET
ERROR: =C2=A0role "basic_use= r" does not exist
SET
ERROR: =C2=A0role "basic_user" d= oes not exist
SET
ERROR: =C2=A0role "basic_user" does not e= xist
ERROR: =C2=A0role "basic_user" does not exist
SET
E= RROR: =C2=A0role "basic_user" does not exist
SET
ERROR: =C2= =A0role "basic_user" does not exist
ERROR: =C2=A0role "ba= sic_user" does not exist
ERROR: =C2=A0role "basic_user" d= oes not exist
ERROR: =C2=A0role "basic_user" does not existSET
ALTER DEFAULT PRIVILEGES
ERROR: =C2=A0role "basic_user"= ; does not exist
SET
ALTER DEFAULT PRIVILEGES
ERROR: =C2=A0role &q= uot;basic_user" does not exist
SET
ALTER DEFAULT PRIVILEGES
E= RROR: =C2=A0role "basic_user" does not exist
SET
ALTER DEFA= ULT PRIVILEGES
ERROR: =C2=A0role "basic_user" does not exist

--
Ard= en


On Thu, Nov 14, 2024 at 12:02=E2=80=AFP= M Adrian Klaver <adrian.kla= ver@aklaver.com> wrote:
On 11/14/24 07:00, Catherine Frock wrote:
> Yes, I still have the backup file. I tried to open pgAdmin4 today to s= ee
> what version I'm running, and now this happened (see attachments).= My
> operating system is Windows 10 Home, version 10.0.19045 Build 19045. I=
> installed Postgres using these instructions:
> https://basill= e.org/postgis2017/installation_instructions/install_postgresql.html <= ;https://basille.or= g/postgis2017/installation_instructions/install_postgresql.html>=C2= =A0I'm guessing at this point I probably need to start all over with th= e installation since pgAdmin4 is not working? But if 9.6 is no longer suppo= rted, can I still use it to access my database? I assumed I would need to m= igrate to the most recent version of PostgreSQL, but maybe that was a wrong= assumption?

1) You can copy/paste the error message=C2=A0 and provide as text.

2) Assuming you are installing Postgres 16 from the EDB package, the
from here:

https://www.postgresql.org/download/windows/

PostgreSQL Version=C2=A0 =C2=A0 =C2=A0 64 Bit Windows Platforms
16=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 2022, 2019

[...]
11=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 2019, 2016, 2012 R2
10=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 2016, 2012 R2 & R1, 7, 8, 10

3) From here:

https://www.enterprisedb.com/dow= nloads/postgres-postgresql-downloads

9.6 can still be downloaded.

It is not a supported version, but you can at least use it to access
your database.


4) You need to provide a more detailed explanation of what you are
trying to achieve.

5) 9.6 -> 16 is six major version jump. That means some research needs <= br> to be done, starting with determining what version of PostGIS you need
to be using.

>
> Thank you for your help,
> --
> Arden
>
>
> On Wed, Nov 13, 2024 at 3:42=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.co= m
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>=C2=A0 =C2=A0 =C2=A0On 11/13/24 10:50, Catherine Frock wrote:
>=C2=A0 =C2=A0 =C2=A0 > I'm seeking help in restoring a database = that was created with
>=C2=A0 =C2=A0 =C2=A0 > PostgreSQL 9.6. I backed it up successfully a= nd have restored it
>=C2=A0 =C2=A0 =C2=A0before,
>=C2=A0 =C2=A0 =C2=A0 > but that was when PostgreSQL 9.6 was still su= pported. After going
>
>=C2=A0 =C2=A0 =C2=A0Do you still have the Postgres 9.6 instance running= ?
>
>=C2=A0 =C2=A0 =C2=A0 > through the installation of PostgreSQL 16.3, = I opened up pgAdmin
>=C2=A0 =C2=A0 =C2=A04 to
>
>=C2=A0 =C2=A0 =C2=A0What version of pgAdmin4?
>
>=C2=A0 =C2=A0 =C2=A0 > try to verify the PostgreSQL/PostGIS=C2=A0ins= tallation, but when I try to
>=C2=A0 =C2=A0 =C2=A0 > connect to the PostgreSQL 16.3 server, I get = an internal server
>=C2=A0 =C2=A0 =C2=A0error
>=C2=A0 =C2=A0 =C2=A0 > message: 'ServerManager' object has n= o attribute 'user_info'.
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > In pgAdmin4, I am able to connect to the Post= greSQL 9.6 server,
>=C2=A0 =C2=A0 =C2=A0but when
>
>=C2=A0 =C2=A0 =C2=A0So the 9.6 instance is running.
>
>=C2=A0 =C2=A0 =C2=A0 > I try to verify the install by querying: CREA= TE EXTENSION postgis;
>=C2=A0 =C2=A0 =C2=A0 > SELECT postgis_version();
>=C2=A0 =C2=A0 =C2=A0 > I get the following error message:=C2=A0=C2= =A0ERROR: could not open extension
>=C2=A0 =C2=A0 =C2=A0 > control file "C:/Program
>=C2=A0 =C2=A0 =C2=A0 > Files/PostgreSQL/9.6/share/extension/postgis.= control": No such
>=C2=A0 =C2=A0 =C2=A0file or
>=C2=A0 =C2=A0 =C2=A0 > directory SQL state: 58P01
>
>=C2=A0 =C2=A0 =C2=A0What OS and version are you running?
>
>=C2=A0 =C2=A0 =C2=A0How did you install Postgres?
>
>
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > How can I restore my database to have access = to it again?
>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > Thanks.
>
>=C2=A0 =C2=A0 =C2=A0--
>=C2=A0 =C2=A0 =C2=A0Adrian Klaver
>=C2=A0 =C2=A0 =C2=A0adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com><= br> >

--
Adrian Klaver
adrian.klave= r@aklaver.com

--00000000000040569506274afc62--