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 1tBbwC-004yKj-1R for pgsql-general@arkaria.postgresql.org; Thu, 14 Nov 2024 15:39:15 +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 1tBbw8-005Ewj-Mh for pgsql-general@arkaria.postgresql.org; Thu, 14 Nov 2024 15:39:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tBbw8-005EwZ-6q for pgsql-general@lists.postgresql.org; Thu, 14 Nov 2024 15:39:12 +0000 Received: from mail-ot1-x331.google.com ([2607:f8b0:4864:20::331]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tBbw4-001vBr-A1 for pgsql-general@lists.postgresql.org; Thu, 14 Nov 2024 15:39:12 +0000 Received: by mail-ot1-x331.google.com with SMTP id 46e09a7af769-7181c0730ddso261958a34.2 for ; Thu, 14 Nov 2024 07:39:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1731598747; x=1732203547; 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=6CiGsx1KL97nKXmjqyEclQktLI86HyOFvEdWLM8/EK4=; b=jZbIwHKqmkKE9sFayToFig0YUuTjtGzenFXNmGa/2u9xWWWV6xVOq4x10VEbr+lKTo Tl0e93pQg7eqo5a94GWtgAcou/3PeNFkgjpuC6XVKoTZiMdTduryZSpcj4DFBxJ8v35P sLWcqksjFNDXjf/qwbuqsOtDi08PHAIf8iNTx0gpVxBGMbPbe/cQhAW5YyyPbXL1Mve7 F3hBMYIY3ireOK/A6YyEyadkz7rNYWXdavvO/yh1BioarcoSSM9VGakYrHmUa3aWp3Tg DXI362tkJROn6Y9pYTisD9mwJUcjXVTkVbOHwbtOAOhq0fP8F/rQnFqjXOyRtaXwOsdH kSgw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1731598747; x=1732203547; 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=6CiGsx1KL97nKXmjqyEclQktLI86HyOFvEdWLM8/EK4=; b=QiQrcPw3uth2CxsKVFBNwy2OANqUZi8/a3g2ZbocgO/NylFmyYYFR6aYXgvbPlIzDS /pgxU9PNZtir6oaihg3h9pnNz0b63rqpC630/Z+9yPBVN5OThnUdB11aBjGhZtD0iMrc M+9ychus+cdOQJqPSFh9lGUzTcsUlIUhQs3fIKSHv/51bFPtfEyOvrKFHgFBy5J+brTZ sMHQDkGlgNIaFc0NVHt+McEEE+tgNNx4oBL1av3RmZQD8rc4y/fx2HrffwbKlwSQj4+K yGFvHzD/SJgEvnXDIh6dfvZ15vDb8pUOC96hlMobuFclmk+i0E+bF4gpDak+ZSlBl3Ty PHAA== X-Forwarded-Encrypted: i=1; AJvYcCUr0ysBSR0qSfQNkXh9HovfNRudbwXfs2GOdhTkJ0dwzjTasuiTaXBMgiVC659gl3ICRmfrhud3/ysWQrNd@lists.postgresql.org X-Gm-Message-State: AOJu0YwFBHcf6OY1ZH14oEyxnxuh9UnchqzoY8RMTOxutujU2X8GN6fx eFBk5ejeKopYterHJHdOiFjahvrdBNgzrveyUDKMyUURWqqcgvZ4ZJCNRr/JjDxVcjQJRgDW6g9 7MRdBzXWxdglBp36JjACcA1uYYq0= X-Google-Smtp-Source: AGHT+IGRR3HkScalSIXt0fPb9iTwnkXum1oTjhzo4ZZTUbT7NbhhhkwSqjuHP1AW5aFb5LZB5ww5CxyLAt4q5Pa6GNQ= X-Received: by 2002:a9d:67cb:0:b0:71a:61b1:55d1 with SMTP id 46e09a7af769-71a61b15644mr6570968a34.0.1731598747544; Thu, 14 Nov 2024 07:39:07 -0800 (PST) MIME-Version: 1.0 References: <1fe9de96-6ebe-4e3a-9b15-ae8a11986664@aklaver.com> In-Reply-To: From: Ron Johnson Date: Thu, 14 Nov 2024 10:38:56 -0500 Message-ID: Subject: Re: Help with restoring database from old version of PostgreSQL To: Catherine Frock Cc: Adrian Klaver , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000003db9dc0626e14010" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003db9dc0626e14010 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 1. PG16 will read a PG 9.6 backup file, so there's no need to install PG 9.6. 2. Installing PG on a OneDrive share is certainly a Very Bad Idea. 3. PG is not the same as PgAdmin. On Thu, Nov 14, 2024 at 10:00=E2=80=AFAM Catherine Frock wrote: > Yes, I still have the backup file. I tried to open pgAdmin4 today to see > 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 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? > > 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 going >> >> 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 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 >> >> So the 9.6 instance is running. >> >> > 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 >> >> 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 >> >> --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000003db9dc0626e14010 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
1. PG16 will read a PG 9.6 backup file, so there's no = need to install PG 9.6.
2. Installing PG on a OneDrive share is certain= ly=C2=A0a Very Bad Idea.
3. PG is not the same as PgAdmin.
<= /div>
O= n Thu, Nov 14, 2024 at 10:00=E2=80=AFAM Catherine Frock <frock@uwalumni.com> wrote:

= On Wed, Nov 13, 2024 at 3:42=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.com= > wrote:
On 1= 1/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 befor= e,
> but that was when PostgreSQL 9.6 was still supported. After going

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=C2=A0installation, 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_inf= o'.
>
> In pgAdmin4, I am able to connect to the PostgreSQL 9.6 server, but wh= en

So the 9.6 instance is running.

> I try to verify the install by querying: CREATE EXTENSION postgis;
> SELECT postgis_version();
> I get the following error message:=C2=A0=C2=A0ERROR: could not open ex= tension
> control file "C:/Program
> Files/PostgreSQL/9.6/share/extension/postgis.control": No such fi= le 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.klave= r@aklaver.com



--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--0000000000003db9dc0626e14010--