Tutorial 3 - How to load/restore DVD rental database to Postgresql server using pgAdmin 4

In this video I showed how to load or restore the DVD rental database to our PostgreSQL sever. We will use this DVD rental database for the next series of videos to understand the various SQL concepts from the beginner level to intermediate/advanced level.

If you have not watched our previous videos, I will encourage you to go watch them because they will give you the foundation needed to better understand this current video and also show you the software you would need to install.

Please see link to our previous videos below:
Tutorial 1 - What is Data? | What is Database? | What is DBMS? | What is SQL?

Tutorial 2 - How to install PostgreSQL and pgAdmin on windows computer | Step-by-Step Guide

**Books I recommend**

DISCLAIMER: This video and description has affiliate links. This means when you buy through one of these links, we will receive a small commission and this is at no cost to you. This will help support us to continue making awesome and valuable contents for you.

[golfy]

wait the dvdrental download is giving me a zip file filled with DAR files and a restore file.. why is that so?

[RamazanAltinisik]

Thanks for your tutorial but I couldn't restore dvdrental.tar because it doesn't see on my mac laptop. How can I fix it .

[shauneblom]

Thank you for this series..it is exactly what I needed for my assignment!

[NotAHomelessGamer]

Thanks for this. For some reason my .tar file looks like a folder in itself, and it has .dat files inside of it. Still works similarly to the way you've done it though.

[yuganshahuja]

C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime\pg_restore.exe --host "localhost" --port "5432" --username "postgres" --no-password --dbname "dvdRental" --verbose

i am facing this error

[ADEspadas]

I had this error with PostgreSQL 16, "Utility file not found. Please correct the Binary Path in the Preferences dialog" but I manage to find the path in FILE-> Preferences-> paths -> binary path, for version16 is "C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime".

The problem I've now is that there's a message of PROCESS FAILED restoring backup on the server PostgreSQL 16 (Localhost5432), I can't open the dvdrental.tar archive, who could I correct this?

[victoriamodupe]

This was very helpful for me....Thanks a lot🤩

[techysuman]

"process failed restoring backup on the server postgresql 16"
Restore failed everytime 😢
I followed the exactly same steps
I'm using latest Postgre SQL 16.1
Please help me sir 🙏

[swanand]

The same steps are not working on Postgres 16. The restore process starts and fails in 5 seconds. Please suggest.

[nateben]

Restore process keeps failing, I tried different versions of postgresSQL :/

[samueljohnson]

I'm not seeing a .tar file when I download the link. What am I doing wrong? Instead, there are several .dat files in the zip.

[MikeJnes-em]

Process failed
It won't restore the zipped file or the extracted version of the file.

[opeyemiaboluje]

Thank you for this sir. But mine keeps saying process failed 😭 what could be the cause? And what can I do to rectify it??

[hossanaegbedare]

What can you do when it say failed instead of completed?

[AYOOLASAHEED-yp]

This very helpful but still can’t be able to add .tar file downloaded to the PostgreSQL. The dvdrental downloaded was a zip file but trying to unzip it to .tar file has been a challenge for me. I am having loads of individual files after unzip the zipped file.

[BibleVerseSpot]

Really helpful to set up. Thanks for the detailed explanation

[karthikshinde]

Even after refresh i can't see tables

[emeraldodi]

This was very helpful. I followed the processes as explained and I was able to upload and restore DVD rental without a hitch. Kudos. I am subscribing right away. Thank you.

[javiermissaelcarrillovilla]

Thanks brou, I need this video excelent my Englihs is not good

[fatimamsani]

thank you for tis mine is telling me pg_restore: error: could not execute query: ERROR: schema "public" already exists