Tutorial 3 - How to load/restore DVD rental database to Postgresql server using pgAdmin 4
Vložit
- čas přidán 22. 08. 2024
- 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.
Please go to this link to download the dvdrental.tar sample database file
www.postgresql...
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 1 - What is D...
Tutorial 2 - How to install PostgreSQL and pgAdmin on windows computer | Step-by-Step Guide
• Tutorial 2 - How to in...
*Books I recommend*
1. Grit: The Power of Passion and Perseverance amzn.to/3EZKSgb
2. Think and Grow Rich!: The Original Version, Restored and Revised: amzn.to/3Q2K68s
3. The Book on Rental Property Investing: How to Create Wealth With Intelligent Buy and Hold Real Estate Investing: amzn.to/3LLpXRy
4. How to Invest in Real Estate: The Ultimate Beginner's Guide to Getting Started: amzn.to/48RbuOb
5. Introducing Python: Modern Computing in Simple Packages amzn.to/3Q4driR
6. Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter 3rd Edition: amzn.to/3rGF73G
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.
Thank you for this series..it is exactly what I needed for my assignment!
I'm glad you like it. Thank you!
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.
Excellent! I'm glad it was very helpful and thanks for subscribing. We hope to provide more awesome content for you.
This was very helpful for me....Thanks a lot🤩
Really helpful to set up. Thanks for the detailed explanation
Glad it was helpful!
wait the dvdrental download is giving me a zip file filled with DAR files and a restore file.. why is that so?
Did you find an answer to this?
yes.. the dvdrental itself (zip file) is the file you will be using.. dont open the zip file. just use the zip file. It doesnt matter if there are DAR files inside.. just use the zip itself@@brentthomas7736
thank you for this tutorial video.
You are welcome!
Thank you for clarifying this for me.
Glad it was helpful!
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 .
The same steps are not working on Postgres 16. The restore process starts and fails in 5 seconds. Please suggest.
I have made a video that should help to fix your issue. The video will drop Monday 12/25/2023 7:45am PST. Watch out!!!
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
Thank you
You're welcome
Thank you so much for this!
You're so welcome!
Thank you very much for this
You're very welcome!
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
untime".
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?
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
Thanks
Thank you!
"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 🙏
I have addressed this problem in another video. Please check this out and let me know if it works. czcams.com/video/vEtYJbHCsmo/video.htmlfeature=shared
Thank you so much.
Thanks for your comment.
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.
I'm guessing your computer is windows 11. When you Double click the zip file once, you should see another folder which is also a compressed folder. However, if you double click again, you will then see the .DAT files. So, you shouldn't double-click the second time. Just double-click once and then use the compressed folder you obtain to load the database. Let me know if it works.
I had same issue and i did as you said. I used the compressed folder to obtain to load database but it did not work.@@tuplespectra
@@tuplespectra double clicking once on the zipped file goes straight into the .dat files.
@@keatonfox-zn5ye I have made a video that should help to fix your issue. The video will drop Monday 12/25/2023 7:45am PST. Watch out!!!
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
Thank you for this sir. But mine keeps saying process failed 😭 what could be the cause? And what can I do to rectify it??
mine fail too
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
@@rominasepulveda570 I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
Process failed
It won't restore the zipped file or the extracted version of the file.
Check out my tutorial 3.1 where I resolved the issue.
muchas gracias brother :)
C:\Program Files\PostgreSQL\16\pgAdmin 4
untime\pg_restore.exe --host "localhost" --port "5432" --username "postgres" --no-password --dbname "dvdRental" --verbose "C:\\Users\\YUGANS~1\\DOWNLO~1\\DVDREN~1.TAR"
i am facing this error
Restore process keeps failing, I tried different versions of postgresSQL :/
Check out my tutorial 3.1 where I explained how the issue was resolved.
Even after refresh i can't see tables
Sorry to hear that Karthik. Could you start again and follow step-by-step? Thanks!
What can you do when it say failed instead of completed?
I explained the solution to this problem in tutorial 3.1. Look for it in my playlist.
Please my dvdrental is not restoring, its writing process failed. My table is still empty whole there is 1 in front of my schema. I've tried severally. What did i not do well?
Can you uninstall the software, restart your computer and start the process again following step by step.
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
Thanks brou, I need this video excelent my Englihs is not good
I'm glad it was helpful.
thank you for tis mine is telling me pg_restore: error: could not execute query: ERROR: schema "public" already exists
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
thank you it did !@@tuplespectra
the file is in my download folder but while restoring its shows nothing
How did you resolve this
@@akshaypy4117 I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
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.
Same here
same, did you ever figure it out?
@@keatonfox-zn5ye I have made a video that should help to fix your issue. The video will drop Monday 12/25/2023 7:45am PST. Watch out!!!
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
Hello sir. Pls why do I get "No archives found" when I click on extract to dvdrentals. Also, my downloaded dvdrentals is not showing as a zip file. Even though when I check properties, it says it is a .tar file. But under type, it's showing as WINRAR Archive.
First thing I think you should do is to start the process afresh and follow the video step-by-step. Make sure you delete the previously downloaded zip file. It may have been corrupted. Let me know what you find. Thanks!
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
just say permission denied to this public schema
I have made a video that should help to fix your issue. Please check out: czcams.com/video/-i6ggi4yHUE/video.html and czcams.com/video/vEtYJbHCsmo/video.html. Let me if it works.
Thank you