Docker and PostgreSQL in [10 Minutes]

Подписаться 993 тыс.

Просмотров 267 тыс.

50% 1

Docker is a fantastic way to run spin up containers that work on any environment removing the saying "BUT IT WORKS ON MY MACHINE". In this tutorial you will learn how to use Docker with Postgres allowing to spin up database instances so that you can have a database for development without any fuss.
Here are the skills you will acquire at the end of this tutorial
➡️ How to spin up a docker container
➡️ Download and run Posgresql Image
➡️ How to Connect to the database instance from
1️⃣ Your local box using psql on the terminal/cmd
2️⃣ Spring Boot 2.+ Application
👉🏽 Following me on my Instagram for programming tips
👨🏽‍💻 amigoscode 👨🏽‍💻
👉🏽 Join me on my brand new Facebook group where we can hold discussions about programming
👍 / 456035171490753 👍
👉🏽 www.amigoscode.com for programming course 👈🏽
If you have any questions please drop a message and do not forget to subscribe to this CHANNEL for more useful videos.

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 220

@najibla 4 года назад

I played the video at 2x speed to get to 10 minutes promised in the title :D

@FIXENDIARY 4 года назад

😂

@classicguy7813 3 года назад

You are dark sir. Time is relatively relative

@teratoma. 3 года назад

@@classicguy7813 obviously not as relative as you believe

@juanpabloriverariffo5599 3 года назад

XDDDDDDD ohh myy gooooooodddd youuu aareeee my herooooo !!!! 😂😂😂😂😂😂

@rawgov 3 года назад

You have shown us how to make @Amigoscode an honest man. Respect.

@martgryfny 4 года назад

Watching spring boot tutorial -> "if you don't know what ist postgres, watch my tutorial" -> stopped watching spring, started watching postgres tutorial -> "if you want to know how to make this app, watch my spring boot tutorial" -> infinite loop

@amigoscode 4 года назад

sorry for the confusion. I meant the course. amigoscode.com/courses/postgresql

@aziz4bliss 4 года назад

I too fell into the similar loop. It is actually frustrating.

@chenchi6623 4 года назад

rofl...

@milesblaq998 4 года назад

lmao this is hilarious man

@krasy8 4 года назад

I'm pretty new to your channel, discovered incidentally while researching tutorials re: spring and must say - LOVING IT!!! Got yourself another subscriber 👍

@amigoscode 4 года назад

Cheers buddy

@tobiasfuchs2502 Год назад

10:00 - 12:00 For those who can't connect with psql from the command line: In my case, I already had a Postgres server running on port 5432. It's because of pgAdmin 4. So always when I tried to connect to the "docker container", it connected to the incorrect server and not the docker one. I fixed it by changing the ports in the run command from 5432:5432 to 5433:5432. Also, change the psql command to "psql -h localhost -p 5433 -U postgres" and it should work. From now on I will avoid using the default port "5432". It took me 1-2 hours to understand the issue.

@maxencepatouillere8883 Год назад

thank you :)

@martinhecht455 Год назад

Gracias!!

@TheMakeupmonika Год назад

"psql -h localhost -p 5433 -U postgres" , can you please explain me why and what that is ? thanks in advance

@amine52824 7 месяцев назад

thanks a lot man

@amine52824 7 месяцев назад

@@TheMakeupmonika all he said was to change the container port to 5433 to avoid dependency issues, that command after is to connect to that container on the port we specified (5433)

@AaronGayah-dr8lu 9 месяцев назад

You have no idea how important this video was to me, thank you. I'll look over your course offerings.

@bxbrenden 3 года назад

This is perfect, great explanation! Docker makes it so much easier to tinker with databases without spending tons of time configuring a service.

@adrianramirez4272 Год назад

Totally agree, containerization is the best !

@stridernative677 2 года назад

Best tutorials I've ever watched from anyone thus far thank you!

@antonhen23 4 года назад

Man, it's just awesome how you connect docker+postgres+javaApp+browserView to show it's working, great!

@kissinger1337 4 месяца назад

The best thing I`ve seen on internet in month. Such a great explanation. Thank you

@ManishKumar-rz9ub 4 года назад

How can we use GUI client to connect to postgress server ?

@amigoscode 4 года назад

Check my video on RU-vid I teach that too

@EdCardinal-MindThump 4 года назад

Very nice, succinct intro. Thanks for saving me a lot of tie and trouble!

@henrikorpela2818 Год назад

Thank you for this video! I managed to get container up and running, but didn't know you were supposed to expose the port to the "outside world". That fixed my issue.

@abdu1wahid105 3 месяца назад

Wow... Amigoscode you did it in just 8 minutes and 51 seconds, thanks!👍

@MrMudbill 3 года назад

Great video, clear and to the point! Thanks

@endybrown3862 Год назад

Thank you for that great video! This is exactly, that I've searched!

@RobertKokorev Год назад

This video has saved me days & probably hundreds of dollars for my client, thanks ^^

@adrianramirez4272 Год назад

Thanks for the crystal clear explanation!

@joanapiovaroli7528 4 года назад

You just saved my day, thank you! Liked and subscribed :)

@amigoscode 4 года назад

Thanks Joana

@MrProgfather 2 года назад

Thank you so much for this! You really saved me a ton of time!

@michelromero7671 2 года назад

Man, this was great. Thanks a lot!!!

@Snegurjan Год назад

Thanks bro, you've saved me a lot of time. Have a nice year!)))

@nightqnearth3617 4 года назад

Thank you for guide, it was really useful! PS. I'm on Windows10-Pro and all steps of this tutorial started works for me just after i completely uninstalled Postgres (and ms sql server just in case... (: ) from my PC.

@rapasebastian5678 4 года назад

Very good explanations! Thank you for the great content!

@amigoscode 4 года назад

Thanks buddy

@user-ql2dh1xq9p 2 года назад

Thank you so much! Helped me to open Vendure postgres project on my machine

@SuprBrian64 4 года назад

This was very helpful. Thanks!

@pappyodanial 2 года назад

My man! Thank you.

@user-qk3ey6tb1k 2 года назад

This is really good lesson. Thank you!

@paulobreim 3 года назад

Good, very good. Simple and direct.

@RuslanSkiraUkraine 3 года назад

It awesome tutorial with explanations and examples. Thank you so much.

@diegoruiz5265 Год назад

I love you so much my friend ! Thanks a lot

@alexandredamiao1365 3 года назад

Great tutorial! Thank you!

@shaankhan1768 5 лет назад

Terrific video, thank you

@mjddev Год назад

Thanks so much fo the help!

@prettyinblack7561 2 года назад

So good explanation, love it..

@estebanisswimming 4 года назад

Thanks! Very helpful! Keep up the good work

@amigoscode 4 года назад

thanks

@uhlysssuh 3 года назад

Thanks! This was calm, clear and GOT THE JOB DONE. (:

@uhlysssuh 3 года назад

subscribed!

@leroywalton4348 2 года назад

these are good infos to start with docker, thanks

@nycolassilvestre2475 4 года назад

Very nice. Thank you!

@felipeministerio7553 5 лет назад

Nice job my boy! Help fuc... a lot

@kolex023 Год назад

Thank you! I subbed :)

@tatemo_labs 4 года назад

short, simple and useful... thanks

@amigoscode 4 года назад

You welcome Gerardo

@shufflepack 3 года назад

Very informative. Thank you

@kylerebstock1487 4 года назад

Great video! the port issue threw me through the window for about 20-30 mins, but the rest is awesome! A script, a few practice runs, and some postop editing could help you meet the 10 minutes if you really wanted to. ;) Thanks again!

@subramanyamramasani1759 2 года назад

How You resolve port issue

@sushantdhakal3117 2 года назад

thanks bro ... liked and subcribed it helped a lot

@ostapbender5791 4 года назад

Great job thank you for your time and tutorial.

@amigoscode 4 года назад

Thanks Ostap

@darwinvelascoecu3815 5 лет назад

Excelente video. La pastilla que necesitaba :)

@amigoscode 5 лет назад

You welcome mate

@vjd5865 4 года назад

you saved my day , huge respect

@amigoscode 4 года назад

Respect brother

@derreck3424 4 года назад

@@amigoscode Respect Amigo

@bouzouidjasidahmed1203 3 года назад

Very useful Thank you brother

@vairasza1578 3 года назад

really good video. helped me alot. thank you. =)

@thiagojaime6589 2 года назад

quick tip. good tip.

@antoineguan 2 года назад

Amazing video

@juanssal Год назад

nice! thanks!

@enlightenedwithkanika 2 года назад

Perfect Video

@limbu966 4 года назад

For anyone on WINDOWS that could not connect to your postgres container from your host machine like he did in the video. Go to Control Panel>Programs and Files>Uninstall postgres>Individual component>postgres server . After that try to connect to your postgres container once again. It should work.

@belitoxavier9058 2 года назад

thanks, working now

@kratom82 Год назад

great, that solved my issues:)

@benaoudamamchaoui8384 Год назад

very helpful bro

@doniwiratmoko1062 5 лет назад

Excellent!

@kennyken7604 2 года назад

great video... I wanted to ask about persistent data and volumes

@Satenc0 2 года назад

Hey buddy it works but do you know why when I try to also run the spring application in a container, it refuses connection to the database? It works when I run on Eclipse but not as a docker container (the jar in it)

@rolandsoftwareguy2515 2 года назад

Thanks for this, it did help on the Docker side. However it seems although Postgres installed on my machine, it did not instal psql😕 Anyone had this? However, although I couldn't run any cli commands on my machine, pgadmin could "see" my databases, but I could run commands from the container while bashed ...could be by design ...although I'm coming from a windows background using a mac so there's probable a "Run as Administrator" type setting I need to use. I'm also using .Net so still some researching to do.

@tiagosutter8821 5 лет назад

Awesome! Thanks!

@amigoscode 5 лет назад

You welcome Tiago

@sanghitasaha8346 Год назад

great explaination , but i am not able to see the test db from localmachine, but its visible when i open from docker container. Thanks

@simonmpoy4747 4 года назад

Great Video! thank you Sir.... subscribed

@amigoscode 4 года назад

Thanks

@cyrilwaechter5065 5 лет назад

Thanks ! Exactly the video I needed to correct errors I made on my first attempt and understand better.

@arunthomas8667 2 года назад

Shouldn't we mount a docker volume so that the data persists even if the container is deleted?

@abhishekagarwal2522 2 года назад

Hey man! I have the following doubts : 1. If I'm using docker postgres image, then also i need to have postgres in my local machine? 2. I didn't understand when you connected local's postgres to docker's postgres. Like what is the point of that? 3. Please correct me if I am wrong but I have different postgres servers on different ports and my local postgres command can point to any of the server. If I am not explicitly telling the port then it uses postgres server by default which got installed while installing it on local (using homebrew, installer file) and if I explicitly mention the port number to connect with, it could be either the docker's postgres server or the local postgres server. Am I correct?

@me360ot 4 года назад

Suggestion at 11:00. You're highlighting the container port and not the localhost port. If a user wants a different local port, they should change the the first number, not the second.

@amigoscode 4 года назад

Yes you are right Thomas.

@skysaville 2 года назад

sure glad i saw this comment! my local version of postgres was already using port 5432 so i had to set the container port to a different port number (ex 5000:5432)

@weplaSpetsnaz Год назад

thank you for your comment I have the local postgres in same 5432 port and I have issues when I try to connect containerized postgres. Changed 5432:5432 to 5000:5432 and my issue is gone. Also I was trying connect directly with container name ( spring.datasource.url=jdbc:postgresql://mycontainername:5432/genel ) and that was keep giving sockettimeoutexception now right property is ( spring.datasource.url=jdbc:postgresql://localhost:5000/genel ) .Sorry for bad english I was stuck there 2 days. I appreciate.

@xenonkz2884 2 года назад

How to install pg_corn in mac os? do we have other alternative system like pg_corn?

@JasonRobards2 Год назад

Super!

@fly_fast777 Год назад

where did 8080 port come from when exposed port was 5432 ? isn't it supposed to be localhost:5432/api/v1/students ?

@java_couch 4 года назад

dude you are the best .I have one question - if i already have a database and want to put in into image what i need to do?

@amigoscode 4 года назад

Thanks buddy. What my course on Docker I teach that

@sega3184 3 года назад

So much thank you

@_i_m_ 3 года назад

A very good tutorial. I am still a bit confused though: what will happen if I load a big database dump to the postgres in the docker container (from bakcup .sql file for example), will docker adjust it's size automatically?

@Pqoq 2 года назад

I tried deploy postgresql 11 on docker: Backed up my 4GB database into 2GB .sql file using pg_dump. Sent the .sql file into docker container using docker cp. After that, I created an empty db and restored the 2GB .sql file into the empty db using psql cli inside the docker, not the psql at the host. After that, the size of my container was just the same as the host. I do not know whether the size is shrinkable (whatever it is called), maybe I could have restored the db inside the container using host's psql without copying the backup first, unnecessary perhaps. edit: container size was before restore:

@TheMrHetch 3 года назад

So, even if i use docker i still have to install docker on my pc?

@aguafria9565 4 года назад

Docker and PostgreSQL in [21 Minutes] < Fixed the title for you bro!!

@tejas6250 3 года назад

he expected that we will watch the video at 2.0x

@TheMakeupmonika Год назад

"psql -h localhost -p 5433 -U postgres" , can you please explain me why and what that is ? thanks in advance

@erwindwi4267 2 месяца назад

thanks bro

@evaveegee64 9 месяцев назад

when i run psql -h localhost -p 5432 -U postgres i get: psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: role "postgres" does not exist

@VitaliyVereschagin 6 лет назад

Thanks

@kuzmamudze9020 Год назад

thx bro☺☺☺

@TheMerdontv 2 года назад

perfect

@vinceramcesoliveros6739 5 лет назад

Great Tutorial! I was kind of lost at some point because I was using Windows and KiteMatic(Electron) App. I got lost at "psql -h localhost -p 5432 -U postgres" because Kitematic predefined another IP address for that container.

@amigoscode 5 лет назад

Find the correct IP and the you should be able to psql into it

@vinceramcesoliveros6739 5 лет назад

@@amigoscode That was already solved, but thanks! my question was, is it okay to use KiteMap? I just followed the tutorial from pgAdmin and it exposes my password in environmental variables. I just want pgAdmin4 GUI in my local machine. it is somehow related to PostgreSQL but with a different platform to establish my own database schema. Thanks!

@jamestomblin9315 4 года назад

Great video, I have what may be an odd or dumb question. What would be a business case for this?

@HughbInc 4 года назад

James Tomblin micro serves, container orchestration, cloud computing, application auto scaling, environmental separation etc. there are multiple. It depends on what business it is.

@Ganjwqeqweqwe 4 года назад

Thanks a lot! Can you show example how do work with images in PostgreSQL?

@amigoscode 4 года назад

Dont store images inside postgres. Check my latest video and I teach how to store images using Amazon S3

@Synox89 4 года назад

At 11:15 I get the error: psql -h localhost -p 5555 -U postgres psql: error: could not connect to server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Why could that be? I deliberately changed the port from 5432 to 5555 because I also have PSQL on my machine and it already uses that port.

@amigoscode 4 года назад

something must be using that port. Try a different one

@everything4u58 4 года назад

@@amigoscode I would like to ask how can I connect PhpPgAdmin to postgresql. A reply would be much appreciated I'm trying since last Tuesday without anything success. Any link of an article would be appreciated too. Thanks in advance

@luisfelipegalleguilloscamp7663 3 года назад

i tried: "docker run --name postgres -e POSTGRES_PASSWORD=pass -p 5432:5432 -d postgres" an it doesnt work, but i did the exact command in the video and its works. What is the difference?

@nobodyspace22 3 года назад

Top from galaxies!

@user-sl1ek4vd9u 4 года назад

Unfortunately my spring boot app dont see my database outside, they see database with name postgres, but my db that i created not. I bootstrap my app like you, and i have acceses outside container but my db with name test_database not available

@ohhi4105 Год назад

the same is happening to me. I created a test db in docker and can't see it from my app. Do you remember how to solve it?

@heyyrudyy404 4 года назад

First of all thank you 🙌 👏 🤝 👍 for your tutorial which help me get a new approach to build backend service with Java. Your content is great and I am testimony of how it's accessible and straight forward to cope with it. I think you could do tutorial on frontend with Angular (essentials and advanced topics) and TypeScript (fundamentals and advanced topics) (type annotation, type inference, type assertion, arrow functions, interfaces, classes, objects, constructors, access modifiers, properties and modules). If it's possible that you could introduce kotlin too with Micronaut framework that would be 🔥 🔥 🔥

@amigoscode 4 года назад

cool I will try

@amargupta1728 4 года назад

Hey Amigo, Thanks and please tell how can I connect postgressql to a boot project that exists in docker?

@amigoscode 4 года назад

Checkout my courses

@HughbInc 4 года назад

APG Learning in boot, locate application.properties Set the postgres jdbc url Update boots Pom file Done;

@qunaturm 4 года назад

thanks a lot from Russia!))

@amigoscode 4 года назад

You welcome

@bokkenka 2 года назад

Great video! Does the data disappear when you stop the instance? Or, is it still there when you restart the instance? Thanks.

@jamie_2452 Год назад

This is the question I have exactly

@fly_fast777 Год назад

@@jamie_2452 it does disappear unless you have created persistent volume

@jamie_2452 Год назад

@@fly_fast777 Yea, you have to set it up to save the data on your local machine for it to persist using -v i think

@NyvekBr 5 лет назад

thanks

@elenaperez6327 3 года назад

Great video! Is it possible to create a database of images using psql, if so, any tips? thanks!

@amigoscode 3 года назад

Database of images what do you mean?

@elenaperez6327 3 года назад

@@amigoscode sorry, newbie here haha. To store a bunch of images (image, title and description) in a database, I read something about blob but I am not sure where to start.

@karlmarxt3792 4 года назад

Hi, I am just stuck with the step at the time 9:35, because I am doing in window 10 pro. could you explain for windows, where to do the process after this time.

@karlmarxt3792 4 года назад

I got the solution myself by working with the SQL Shell(psql)

@amigoscode 4 года назад

open psql on your seach bar and thats all

@suchithsuddala 4 года назад

when connecting attempting to connect to the database from local, I got this error: psql: error: could not connect to server: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? (I am on a windows system) I made sure the port was exposed and that none of my firewalls are blocking port 5432. Do you what else could be causing this?

@daksheshnimishe1485 4 года назад

Had the same issue, maybe we can link up and find a solution?

@PlaYourSongianis 4 года назад

You can configure an other port on docker i guess ?

@mayurdhande8712 3 года назад

Awesome tutorial. I have a question here. Every time I restart the container, all my databases and tables are getting removed, and I am getting a fresh installed copy. Is there any extra parameter needs to provide to persist the state ?