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 <fr...@uwalumni.com> 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 <adrian.kla...@aklaver.com> > 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.kla...@aklaver.com >> >> -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
