Re: Help with restoring database from old version of PostgreSQL

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Help with restoring database from old version of PostgreSQL
Дата
Msg-id CANzqJaCHsrrmCkg0xPP_mpi=cZJ4Nbty+ihU2yUa12Mj9+Ww5g@mail.gmail.com
обсуждение исходный текст
Ответ на Help with restoring database from old version of PostgreSQL  (Catherine Frock <frock@uwalumni.com>)
Список pgsql-general
On Wed, Nov 13, 2024 at 1:50 PM 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 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?

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.

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

В списке pgsql-general по дате отправления: