r/SQL•
SquintsPaledorous

Trying to restore Sean Lahman's baseball .bak database to pgadmin4; restore failed

PostgreSQL

I'm on my mac running through Jose Portilla's SQL udemy course on pgadmin4/postgreSQL and have had no issues running or manipulating the dvdrental .tar file.

I'm trying to restore Sean Lahman's .bak baseball database to a new database in pgadmin4, and when i click restore i get a "Process failed restoring backup on the server SQL16...." error.

I'm new to SQL and just messing around in the program, so i'm unsure where to go from here.

The only thing I think it could be, is when i run SELECT version() it tells me its running PostgreSQL 16.4, and when i validate my binary paths it says 16.3. But it does the same thing for the dvdrental database and im not having any issues with that, so idk

Posted Aug 14, 2024, 2:15 AM UTC

10
Loading comments…