Search Postgresql Archives

Re: Help with restoring database from old version of PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You say that you just installed PG17.  That's perfectly fine.   If pgAdmin4 version 8.12 is recent, then it's fine to use that, too.

The thing is that sql files are just... a bunch of SQL statements.  Whatever SQL is generated by v9.6 will be easily processed by a modern version.

On Tue, Nov 19, 2024 at 5:13 PM Catherine Frock <frock@xxxxxxxxxxxx> wrote:
Do you know what versions of PG and pgAdmin4 I need? Also, I don't know where to get a different version of PG.

--
Arden


On Tue, Nov 19, 2024 at 5:01 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:
Ah, so it's a plain old SQL file.  That makes things much easier!!

Here's the thing: PG (whether 9.6 or 16 or 17) is the database engine; no GUI, and just a basic command line interface.
PgAdmin4 is a GUI interface to PG.  Newer versions of PgAdmin4 are not compatible with EOL PG versions like 9.6.

What you need is both a new PG version and a new PgAdmin4 version.

Then you need to:
    CREATE USER basic_user WITH PASSWORD 'random_horse';

After that, you can run the "backup sql script".

On Tue, Nov 19, 2024 at 4:47 PM Catherine Frock <frock@xxxxxxxxxxxx> wrote:
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 toC:\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:  database "db_2017" does not exist
COMMENT
CREATE SCHEMA

[snip] 
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
[snip] 
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

 

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


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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux