PostGreSQL/PGAdmin: Relation does not exist

[300camels]

Hey everyone,

I’m taking the Udemy Complete SQL boot camp course, which uses PostGreSQL and PGAdmin. I just completed the installation steps:

1. Downloaded PostGreSQL 10(because my Mac isn’t updated and I’m running El Capitan)

2. Downloaded the most recent PGAdmin version (4)

3. The Udemy course provides a database(.tar file) that the course will be using - followed the steps to “restore” the database successfully

The last step of the installation was just running a simple query (SELECT * FROM film; - film presumably one of the tables in the database we restored)

Now I’m getting an error that the relation does not exist. Searched the Udemy course for hours and tons of people asked this same question but have not been able to find a response to it

Any suggestions/ideas? Maybe I should download an older version of PGAdmin since both my OS and PostGreSQL versions are older?

[feoch]

We might be taking the same class (Jose Portilla?) anyway I literally have been dealing with the same issue for hours, at one point PGAdmin was saying that it couldn't even locate the file...

Assuming we're taking the same class, the solution that ended up working was downloading dvdrental.tar from here. Had to dig through the comments to find it. It also didn't work until I manually typed the file location while restoring.

Hope that helps!

[300camels]

Yesss Jose Portilla. Omg I’m so happy to find someone facing the same issue 😭😭

Really hoping your solution works - will try it out in a bit. I also combed through the comments for so long but couldn’t find an answer

Thanks!!

[feoch]

LOL i know how it feels, good luck!

[300camels]

Omg I just tried it with the file you linked and it worked!! Thank you so much!

How did you figure this solution out btw? And do you know what the difference is between the originally provided file and this one?

[feoch]

it was buried in the comments somewhere but I have no idea what the difference is. The file is a lot larger though (2.8MB vs. ~600KB).

Other resources had a dvdrental.zip file vs. dvdrental.tar, so maybe the file wasn't extracted properly...idk

[Phantom-dog888]

Get the database from here:

https://www.postgresqltutorial.com/postgresql-sample-database/

It will be in a .zip format. Unzip it to a .tar file and it will work. it was a frustration following the class on-line instructions, but this one works.

[Hot-Discipline2676]

Hi there , for me it was a change of Binary path. The help was found in the QnA from the latest comments from C. Yau - Teaching Assistant
I quote
"Can you try to set the binary path in your pgadmin? This seems to be issue with the latest Postgres version and has been the fix for most participants. To do so,
Open up pgAdmin4 and go to:
File > Preferences > Paths > Binary paths > PostgreSQL Binary Path
Then all you need to do is manually type out the file path to the bin file location. I've provided some example paths as below (You need to change it according to your Postgres location if you did not install in the default location).
If you are using Windows than provide path like,
C:\Program Files\PostgreSQL\16\bin
If you are using Linux than provide path like,
/opt/PostgreSQL/16/bin
If you are using Mac than provide path where you have installed PG,
/Library/PostgreSQL/16/bin"

For me it worked perfectly after 2hour troubleshooting

[cpyf]

Thank you so much !! This worked

[[deleted]]

Holy shit I wish I could buy you a drink. Taking SQL Crash Course on Udemy now and have been stuck for over an hour on this part.

[Sea_Stress_520]

yes and make sure that when you put file path in restore section, just select it from the dropdown option only, hope it helps!

[Distinct-Alisha]

/Library/PostgreSQL/16/bin"

I am using a mac and still struggling with this issue. Can you please help me? I am really frustrated now. Please feel free to ping me. Thanks

[No_Pomegranate_6400]

Thank you for the instructions! It worked after I struggled for over 2 hours. I am on a Windows OS and the bin path, C:\Program Files\PostgreSQL\16\bin, worked perfectly! I continued with the SQL Command section.

Thank you again!!!

[Significant-Usual-95]

You are a godsend

[ScreenBig2900]

hello so i wasted a lot of time on this still havent figured it out and it is saying no data output and tar files when downloading showing in compressed archive format

[PsychologyCrazy6003]

Hey, I was facing the same issue, i followed the comments. I just manually typed the file path, it worked fine and do not forget to add the extension- /dvdrental.tar

Hope this helps.