I played the video at 2x speed to get to 10 minutes promised in the title :D
@FIXENDIARY4 жыл бұрын
😂
@classicguy78134 жыл бұрын
You are dark sir. Time is relatively relative
@teratoma.3 жыл бұрын
@@classicguy7813 obviously not as relative as you believe
@juanpabloriverariffo55993 жыл бұрын
XDDDDDDD ohh myy gooooooodddd youuu aareeee my herooooo !!!! 😂😂😂😂😂😂
@rawgov3 жыл бұрын
You have shown us how to make @Amigoscode an honest man. Respect.
@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
@amine5282410 ай бұрын
thanks a lot man
@amine5282410 ай бұрын
@@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)
@martgryfny4 жыл бұрын
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
@amigoscode4 жыл бұрын
sorry for the confusion. I meant the course. amigoscode.com/courses/postgresql
@aziz4bliss4 жыл бұрын
I too fell into the similar loop. It is actually frustrating.
@chenchi66234 жыл бұрын
rofl...
@milesblaq9984 жыл бұрын
lmao this is hilarious man
@AaronGayah-dr8lu Жыл бұрын
You have no idea how important this video was to me, thank you. I'll look over your course offerings.
@bxbrenden3 жыл бұрын
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 !
@limbu9664 жыл бұрын
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.
@belitoxavier90582 жыл бұрын
thanks, working now
@kratom82 Жыл бұрын
great, that solved my issues:)
@kissinger13377 ай бұрын
The best thing I`ve seen on internet in month. Such a great explanation. Thank you
@antonhen234 жыл бұрын
Man, it's just awesome how you connect docker+postgres+javaApp+browserView to show it's working, great!
@RobertKokorev Жыл бұрын
This video has saved me days & probably hundreds of dollars for my client, thanks ^^
@abdu1wahid1056 ай бұрын
Wow... Amigoscode you did it in just 8 minutes and 51 seconds, thanks!👍
@krasy84 жыл бұрын
I'm pretty new to your channel, discovered incidentally while researching tutorials re: spring and must say - LOVING IT!!! Got yourself another subscriber 👍
@amigoscode4 жыл бұрын
Cheers buddy
@aguafria95654 жыл бұрын
Docker and PostgreSQL in [21 Minutes] < Fixed the title for you bro!!
@tejas62503 жыл бұрын
he expected that we will watch the video at 2.0x
@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.
@stridernative6772 жыл бұрын
Best tutorials I've ever watched from anyone thus far thank you!
@ГарикВонави2 жыл бұрын
Thank you so much! Helped me to open Vendure postgres project on my machine
@tatemo_labs4 жыл бұрын
short, simple and useful... thanks
@amigoscode4 жыл бұрын
You welcome Gerardo
@Snegurjan Жыл бұрын
Thanks bro, you've saved me a lot of time. Have a nice year!)))
@kennyken76042 жыл бұрын
great video... I wanted to ask about persistent data and volumes
@endybrown38622 жыл бұрын
Thank you for that great video! This is exactly, that I've searched!
@nightqnearth36174 жыл бұрын
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.
@adrianramirez4272 Жыл бұрын
Thanks for the crystal clear explanation!
@me360ot5 жыл бұрын
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.
@amigoscode5 жыл бұрын
Yes you are right Thomas.
@skysaville2 жыл бұрын
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.
@bokkenka2 жыл бұрын
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
@paulobreim3 жыл бұрын
Good, very good. Simple and direct.
@pappyodanial2 жыл бұрын
My man! Thank you.
@leroywalton43482 жыл бұрын
these are good infos to start with docker, thanks
@arunthomas86673 жыл бұрын
Shouldn't we mount a docker volume so that the data persists even if the container is deleted?
@diegoruiz5265 Жыл бұрын
I love you so much my friend ! Thanks a lot
@abhishekagarwal25223 жыл бұрын
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?
@joanapiovaroli75284 жыл бұрын
You just saved my day, thank you! Liked and subscribed :)
@amigoscode4 жыл бұрын
Thanks Joana
@fly_fast777 Жыл бұрын
where did 8080 port come from when exposed port was 5432 ? isn't it supposed to be localhost:5432/api/v1/students ?
@michelromero76712 жыл бұрын
Man, this was great. Thanks a lot!!!
@rolandsoftwareguy25153 жыл бұрын
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.
@mjddev Жыл бұрын
Thanks so much fo the help!
@shufflepack3 жыл бұрын
Very informative. Thank you
@EdCardinal-MindThump4 жыл бұрын
Very nice, succinct intro. Thanks for saving me a lot of tie and trouble!
@sushantdhakal31172 жыл бұрын
thanks bro ... liked and subcribed it helped a lot
@sanghitasaha83462 жыл бұрын
great explaination , but i am not able to see the test db from localmachine, but its visible when i open from docker container. Thanks
@bouzouidjasidahmed12033 жыл бұрын
Very useful Thank you brother
@prettyinblack75613 жыл бұрын
So good explanation, love it..
@evaveegee6411 ай бұрын
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
@RuslanSkiraUkraine4 жыл бұрын
It awesome tutorial with explanations and examples. Thank you so much.
@MrProgfather2 жыл бұрын
Thank you so much for this! You really saved me a ton of time!
@thiagojaime65892 жыл бұрын
quick tip. good tip.
@MrMudbill3 жыл бұрын
Great video, clear and to the point! Thanks
@СанжарАбдуллаев-к8м2 жыл бұрын
This is really good lesson. Thank you!
@alexandredamiao13653 жыл бұрын
Great tutorial! Thank you!
@SuprBrian644 жыл бұрын
This was very helpful. Thanks!
@rapasebastian56784 жыл бұрын
Very good explanations! Thank you for the great content!
@amigoscode4 жыл бұрын
Thanks buddy
@nycolassilvestre24754 жыл бұрын
Very nice. Thank you!
@Satenc03 жыл бұрын
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)
@kolex023 Жыл бұрын
Thank you! I subbed :)
@enlightenedwithkanika2 жыл бұрын
Perfect Video
@antoineguan2 жыл бұрын
Amazing video
@benaoudamamchaoui83842 жыл бұрын
very helpful bro
@elenaperez63273 жыл бұрын
Great video! Is it possible to create a database of images using psql, if so, any tips? thanks!
@amigoscode3 жыл бұрын
Database of images what do you mean?
@elenaperez63273 жыл бұрын
@@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.
@estebanisswimming4 жыл бұрын
Thanks! Very helpful! Keep up the good work
@amigoscode4 жыл бұрын
thanks
@uhlysssuh3 жыл бұрын
Thanks! This was calm, clear and GOT THE JOB DONE. (:
@uhlysssuh3 жыл бұрын
subscribed!
@felipeministerio75536 жыл бұрын
Nice job my boy! Help fuc... a lot
@juanssal2 жыл бұрын
nice! thanks!
@Ganjwqeqweqwe4 жыл бұрын
Thanks a lot! Can you show example how do work with images in PostgreSQL?
@amigoscode4 жыл бұрын
Dont store images inside postgres. Check my latest video and I teach how to store images using Amazon S3
@mayurdhande87124 жыл бұрын
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 ?
@rafaelcalderon66583 жыл бұрын
Yo need to create a Volume in Docker to persist the data... Search in the docker Docs for Volumes
@darthvader81443 жыл бұрын
@@rafaelcalderon6658 i dont wanna search, just explain me
@rolandsoftwareguy25153 жыл бұрын
@@darthvader8144 😂😂😂😂
@vairasza15783 жыл бұрын
really good video. helped me alot. thank you. =)
@jamestomblin93155 жыл бұрын
Great video, I have what may be an odd or dumb question. What would be a business case for this?
@HughbInc4 жыл бұрын
James Tomblin micro serves, container orchestration, cloud computing, application auto scaling, environmental separation etc. there are multiple. It depends on what business it is.
@ItachiUchiha-fo9zg3 жыл бұрын
on windows....if you have installed psql just now.... your local server will be started immediately...so switch it off using *** pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" stop *** then your psql picks up docker insatnce
@ostapbender57914 жыл бұрын
Great job thank you for your time and tutorial.
@amigoscode4 жыл бұрын
Thanks Ostap
@Synox894 жыл бұрын
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.
@amigoscode4 жыл бұрын
something must be using that port. Try a different one
@everything4u584 жыл бұрын
@@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
@vjd58655 жыл бұрын
you saved my day , huge respect
@amigoscode5 жыл бұрын
Respect brother
@derreck34245 жыл бұрын
@@amigoscode Respect Amigo
@TheMakeupmonika Жыл бұрын
"psql -h localhost -p 5433 -U postgres" , can you please explain me why and what that is ? thanks in advance
@kylerebstock14874 жыл бұрын
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!
@subramanyamramasani17592 жыл бұрын
How You resolve port issue
@shaankhan17685 жыл бұрын
Terrific video, thank you
@qunaturm4 жыл бұрын
thanks a lot from Russia!))
@amigoscode4 жыл бұрын
You welcome
@_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?
@Pqoq2 жыл бұрын
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:
@vinceramces5 жыл бұрын
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.
@amigoscode5 жыл бұрын
Find the correct IP and the you should be able to psql into it
@vinceramces5 жыл бұрын
@@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!
@darwinvelascoecu38155 жыл бұрын
Excelente video. La pastilla que necesitaba :)
@amigoscode5 жыл бұрын
You welcome mate
@TheMerdontv2 жыл бұрын
perfect
@amargupta17284 жыл бұрын
Hey Amigo, Thanks and please tell how can I connect postgressql to a boot project that exists in docker?
@amigoscode4 жыл бұрын
Checkout my courses
@HughbInc4 жыл бұрын
APG Learning in boot, locate application.properties Set the postgres jdbc url Update boots Pom file Done;
@simonmpoy47474 жыл бұрын
Great Video! thank you Sir.... subscribed
@amigoscode4 жыл бұрын
Thanks
@xenonkz28843 жыл бұрын
How to install pg_corn in mac os? do we have other alternative system like pg_corn?
@suchithsuddala4 жыл бұрын
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?
@daksheshnimishe14854 жыл бұрын
Had the same issue, maybe we can link up and find a solution?
@PlaYourSongianis4 жыл бұрын
You can configure an other port on docker i guess ?
@JasonRobards22 жыл бұрын
Super!
@ИгорьКузьмин-ч1д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?
@erwindwi42675 ай бұрын
thanks bro
@doniwiratmoko10625 жыл бұрын
Excellent!
@heyyrudyy4044 жыл бұрын
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 🔥 🔥 🔥
@amigoscode4 жыл бұрын
cool I will try
@sega31844 жыл бұрын
So much thank you
@tiagosutter88215 жыл бұрын
Awesome! Thanks!
@amigoscode5 жыл бұрын
You welcome Tiago
@TheMrHetch4 жыл бұрын
So, even if i use docker i still have to install docker on my pc?
@cyrilwaechter50655 жыл бұрын
Thanks ! Exactly the video I needed to correct errors I made on my first attempt and understand better.
@luisfelipegalleguilloscamp76633 жыл бұрын
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?
@pynchia41194 жыл бұрын
Where is the DB data kept? Point out you use Java. Any specific reason to use a uuid as an id?? Lots of little annoying inconsistencies
@kuzmamudze90202 жыл бұрын
thx bro☺☺☺
@karlmarxt37925 жыл бұрын
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.
@karlmarxt37925 жыл бұрын
I got the solution myself by working with the SQL Shell(psql)
@amigoscode5 жыл бұрын
open psql on your seach bar and thats all
@kushsharma6653 Жыл бұрын
One key point you have missed is that postgres expects the username to be same as database name. Else it wont work
@SaudiArabiaKingdom4 жыл бұрын
docker exec -it psql bash the input device is not a TTY. If you are using mintty, try prefixing the command with 'winpty'
@amigoscode4 жыл бұрын
👍
@bostamusicbrazil3 жыл бұрын
Top from galaxies!
@olgunkaya_6 жыл бұрын
Thanks but the port info is incorrect. from the docker documentation; -p 8080:80 Map TCP port 80 in the container to port 8080 on the Docker host. the first port is the host port while the second port is the container one.
@ttsrg5 жыл бұрын
What did you tell about?
@VitaliyVereschagin6 жыл бұрын
Thanks
@MoroseGrouch4 жыл бұрын
if i didnt install this should i be worried that it is there?
@zafarmamarakhimov69145 жыл бұрын
Useful video. However, I don't see the database created in docker when I connect through localhost
@amigoscode5 жыл бұрын
You need to create the database your self. CREATE DATABASE nameofdb;
@zafarmamarakhimov69145 жыл бұрын
@@amigoscode Yes that's what I did. But when I start docker postgres app would not start saying that 5432 is already in use. Docker and postgres are both using the same port.
@amigoscode5 жыл бұрын
@@zafarmamarakhimov6914 you can map 5432 to something else then. like 5432:2345
@zafarmamarakhimov69145 жыл бұрын
@@amigoscode actually it should be 2345:5432. It took 2 hours to make it to work