public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: Catherine Frock <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Help with restoring database from old version of PostgreSQL
Date: Thu, 14 Nov 2024 10:38:56 -0500
Message-ID: <CANzqJaDF9aeQVeLQ41UhkeUxHLi03-uUHx_eb2pYUWpXbyndNA@mail.gmail.com> (raw)
In-Reply-To: <CAAkgG6jLBV81cN7ogJF0bHj3ymFJ87ULmbnuX=De2rndoTGNXw@mail.gmail.com>
References: <CAAkgG6hSWMwUUivGzoi_ku6JNXmTVXC2mP7XY5Xs+QPnvKjAdQ@mail.gmail.com>
<[email protected]>
<CAAkgG6jLBV81cN7ogJF0bHj3ymFJ87ULmbnuX=De2rndoTGNXw@mail.gmail.com>
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 AM Catherine Frock <[email protected]> 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_postgresql.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 need
> 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 PM Adrian Klaver <[email protected]>
> 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
>> [email protected]
>>
>>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
view thread (11+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Help with restoring database from old version of PostgreSQL
In-Reply-To: <CANzqJaDF9aeQVeLQ41UhkeUxHLi03-uUHx_eb2pYUWpXbyndNA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox