Docker is a product that allows developers to create containers, which are self-contained areas on their computer for running applications. They can be used for databases, which is great if you can’t install it normally (e.g. you use a Mac).
This video shows you how to set up a PostgreSQL database on Docker. It uses an existing PostgreSQL image on the Docker Hub website. You can use many different versions of PostgreSQL, not just the latest version.
You’ll learn how to download and install Docker, find the right PostgreSQL image, download the image, run it, and connect to it in the DBeaver IDE. You can use any other IDE that works with PostgreSQL if you prefer.
The connection details for this image mentioned in the video are below.
Host: localhost
Port: 5432
Username: postgres
Password: whatever you specify in the “docker run“ command (default is mysecretpassword)
Timestamps:
00:00 In this video
00:05 High-level steps
00:29 Download Docker
01:23 Run Docker
02:07 Create Docker Hub account
02:41 Search for PostgreSQL image on Docker Hub
03:15 Understand the docker run command
04:29 Adjust docker run command
05:19 Open Terminal and login to Docker
06:12 Download image using Docker Run
06:52 Check status using docker ps
07:19 Connect using DBeaver
07:47 Enter connection details
08:43 Run simple query
09:05 Docker Stop command
/// RESOURCES
Get my free SQL Cheat Sheets for Oracle, SQL Server, MySQL, and Postgres here:
SQL Roadmap: an overview of SQL topics, which is a great place to start:
Contact me here for questions, sponsorship requests, and more:
Want to take your database and SQL skills to the next level? Sign up for Database Star Academy, the online platform for database development and SQL. Check it out here:
1 view
214
85
2 months ago 01:33:20 1
Reinhardt Buhr - The Space Between (2021 Full Album) - Ambient Ableton Live Looping
2 months ago 00:03:19 1
How’s It Gonna Be? (Official Video)
2 months ago 00:06:21 1
How to Invest Tether USDT and Earn up to 10% Profit Daily | Best USDT Investment Website 2024
2 months ago 00:05:14 1
Unlock the Power of Local SEO! Learn How with Local Kingdom: Lead Generation SEO – Now 91% Off!
2 months ago 00:04:24 1
Ed Sheeran - Shape of You (Official Music Video)
2 months ago 00:04:36 1
Данечка собирается в Африку / Daniela goes to Africa
2 months ago 00:08:59 1
Execution by Their Own Hands: How Russian Soldiers Chose Death Instead of Resistance
2 months ago 00:08:02 1
Dill Erases all wrinkles on the face! 100 year old recipe! Top Recipes
2 months ago 00:22:15 1
🧪🧪🧪🧪Прорыв в технологии Варп-двигателя.
2 months ago 00:02:20 1
Decadent | “Madness” Trailer
2 months ago 00:10:31 1
Basic Handgun Calibers Explained - Semi-Automatic Ammo Breakdown
2 months ago 00:34:43 1
30 Minute Full Body Cardio HIIT Workout [NO REPEAT]
2 months ago 00:25:36 1
People CHANGE When They Know You’re a Chosen One! (7 Shocking Behaviors You Won’t Believe!)
2 months ago 00:55:10 1
Albania migration scam & Hijab CIVIL WAR in Islam
2 months ago 00:05:00 1
Heilung | Anoana [Official Video]
2 months ago 00:20:03 1
Is It Pyramids All The Way Up? - Questions For Corbett
2 months ago 01:27:01 1
#ЯВОЛОНТЕР. Истории неравнодушных. Режиссёрская версия
2 months ago 00:22:13 1
How did Hezbollah’s chief react to Israel’s 2-day terror blitz? | The Cradle Bytes
2 months ago 01:15:01 1
Scott Ritter: Lebanon Device Attacks, Hezbollah Military Strategy & The BRICS Palestine Solution
2 months ago 00:01:46 1
1 ЛОЖКА В КОМПОСТ и ПЕРЕПРЕЮТ ДАЖЕ КОСТИ! Безопасный БЫСТРЫЙ СУПЕРкомпост уже для ОСЕННИХ посадок.
2 months ago 01:41:50 2
Ashish Sharma: ’I was replaced last minute in an Aishwarya Rai Akshay Kumar movie by ...!’
2 months ago 00:04:15 1
Stop T vs No T - American English Pronunciation
2 months ago 00:06:04 1
Pokemon Go Hack 2024 - Pokemon Go Spoofer with Joystick Teleport GPS iPOGO (iOS & Android)