How to Set Up a PostgreSQL Database with Docker

  Рет қаралды 186,695

Database Star

Database Star

Күн бұрын

Пікірлер: 235
@imransadiq5851
@imransadiq5851 2 жыл бұрын
For all those who are getting Fatal error, password authentication error etc. Use postgres as username in the database connection dbeaver. The - - name some-name in the run command is only used to stop or resume the container it is not the login user name of the database.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks for the tip!
@ishayfrenkelYT
@ishayfrenkelYT Жыл бұрын
Such a good video and explanation, after a while I mumbled around the web, your 10 minute video got me exactly where I needed. Thank you!
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks, glad it helped! Yeah I found many of the other Docker tutorials weren't that helpful.
@pongstr
@pongstr 8 ай бұрын
this video is practically reading a readme with extra steps
@esmaelmohamed8209
@esmaelmohamed8209 2 ай бұрын
All is true for me also!
@DatabaseStar
@DatabaseStar 23 күн бұрын
Get your FREE cheat sheet of Docker commands: www.databasestar.com/docker-database-cheat-sheet/?
@JeffreyMRose
@JeffreyMRose 2 жыл бұрын
Near the beginning of the video, the author claimed that "some-postgres" is the name of the image and near the end, he said it's the name of the container. They are two separate things.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Good point, yea you are right they are different. Thanks for mentioning it here for others to notice too.
@jlacerd4
@jlacerd4 Жыл бұрын
I can't express how grateful I am for this video. Thank you so muuuuuch, you have no idea how much you helped me!
@DatabaseStar
@DatabaseStar Жыл бұрын
No problem, I’m glad it helped you!
@easilyCoded
@easilyCoded Жыл бұрын
To anyone getting this error: FATAL: password authentication failed for user "postgres" The problem is you probably already have postgres installed in your machine, and probably running, which is using the same port docker is trying to use. To solve this, you just need to uninstall the postgres already installed in your machine if you dont have any relevant db in it. Docker already have postgres and some other list of databases there, like you see from the video (7:40), when you click to connect from your DBeaver, you can choose postgres from the list, and your connection should be up and running.... hopefully that helps!
@DatabaseStar
@DatabaseStar Жыл бұрын
Awesome, thanks for the tip and solution!
@mauriciocantu9373
@mauriciocantu9373 Жыл бұрын
I love you so much, marry me
@tahirmahmudzade6386
@tahirmahmudzade6386 Жыл бұрын
Wouldn't simply changing port help?
@Jjr.001
@Jjr.001 3 ай бұрын
thanks a lot
@vii2903
@vii2903 2 ай бұрын
thank you so much! i was stressed out looking for an error that doesn't exist
@amanjang7531
@amanjang7531 3 жыл бұрын
Thank you for explaining this better, and more succinctly than my college materials 🤝 👍
@DatabaseStar
@DatabaseStar 3 жыл бұрын
Happy to help!
@asfasdfsd8476
@asfasdfsd8476 2 жыл бұрын
for anyone having error: FATAL: password authentication failed for user "postgres" - uninstall postgres server on your main OS, it blocks port
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks for sharing, I think I’ve had that same error before too.
@NikGoodrich
@NikGoodrich Жыл бұрын
@@DatabaseStar Can you pin this? Our whole class had this problem from another Postgres lesson
@JoshuaNeedham
@JoshuaNeedham Жыл бұрын
Wouldn't setting a different port be a better option here? Seems excessive to remove postures from your hd.
@collinsnnadozie5092
@collinsnnadozie5092 8 ай бұрын
U can use another new port by mapping it -p 5431:5432
@sahilgarg94
@sahilgarg94 7 ай бұрын
@@collinsnnadozie5092 this must be pinned
@rodrigobaiao3420
@rodrigobaiao3420 9 ай бұрын
This is the BEST tutorial I've ever seen!!!!
@DatabaseStar
@DatabaseStar 9 ай бұрын
Thanks! Glad you like it
@emirkaancati5218
@emirkaancati5218 Жыл бұрын
That was a really simple and instructive video. Thanks.
@DatabaseStar
@DatabaseStar Жыл бұрын
Glad it was helpful!
@sandeepgamot4585
@sandeepgamot4585 3 жыл бұрын
Hey thanks man, very helpful. Also I saw your channel is dedicated to database. I'm trying to learn database design and found not many good resources for that, probably you can take that up as video playlist? Like given a app idea or feature idea, design a database that's efficient
@DatabaseStar
@DatabaseStar 3 жыл бұрын
Glad you liked the video! Yeah it is dedicated to databases. Sure I can create a playlist for that. I have a couple of videos on database design, but haven't created that many. I'll create some more soon.
@ShafiqNazrin
@ShafiqNazrin Жыл бұрын
You really helped me test the connection by making the video. Thanks man
@DatabaseStar
@DatabaseStar Жыл бұрын
You’re welcome!
@marioandresheviacavieres1923
@marioandresheviacavieres1923 10 ай бұрын
Excellent explanations. Thanks a lot for the clarity. From now I'm a new of your channel followers. Thanks a lot Ben!
@DatabaseStar
@DatabaseStar 10 ай бұрын
Awesome, thank you!
@XenidRol
@XenidRol Жыл бұрын
Thank you for that elaborate and concise explanation!
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks! Glad it was helpful!
@MBinDenver
@MBinDenver 4 ай бұрын
Thank you for this! Extremely easy given your tutorial...
@DatabaseStar
@DatabaseStar 4 ай бұрын
You're very welcome!
@yusiff
@yusiff Жыл бұрын
I love the way you explain, thanks a lot!
@DatabaseStar
@DatabaseStar Жыл бұрын
You're welcome!
@ramiworkstation
@ramiworkstation 4 ай бұрын
This lesson is as sweet as Sugar. 🍬🍬Thank you for sharing
@DatabaseStar
@DatabaseStar 4 ай бұрын
You’re welcome!
@БоряДикий
@БоряДикий 6 ай бұрын
great video, thank you for such an easy explanation!
@DatabaseStar
@DatabaseStar 6 ай бұрын
You're very welcome!
@hpz3375
@hpz3375 5 ай бұрын
thank you sir, in my case I was creating everything well, except for the port binding between host:container , leaving that blank
@DatabaseStar
@DatabaseStar 5 ай бұрын
Good to hear you got it solved.
@anurag3487
@anurag3487 7 ай бұрын
great video, crisp and clear
@DatabaseStar
@DatabaseStar 7 ай бұрын
Thanks!
@missman4264
@missman4264 Жыл бұрын
Hello, could you help me I get this error > FATAL: role "postgres" does not exist ; Don't understand what I did wrong
@DatabaseStar
@DatabaseStar Жыл бұрын
Hmm I'm not sure what the issue could be. I assume you're using the same docker command as on the website. Perhaps there's a missing character or a spelling issue. Otherwise, I'm not sure.
@faqihainulyaqinnursaid656
@faqihainulyaqinnursaid656 Жыл бұрын
Thank you so much for the tutorial. It is very helpful for me, also u explain all steps very clear, good job.
@DatabaseStar
@DatabaseStar Жыл бұрын
Glad to hear it was helpful!
@sebastineodeh8612
@sebastineodeh8612 Жыл бұрын
Thank you so much, this was all I needed.
@DatabaseStar
@DatabaseStar Жыл бұрын
Glad it helped!
@kimhongsieng6457
@kimhongsieng6457 2 жыл бұрын
Great video. I try to follow your video but I get the error as below: "INTERNAL SERVER ERROR: Unable to connect to server: connection to server at "localhost"(::1), port 5432 failed:
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Hmm I’m not sure how to solve that one unfortunately. Glad you liked the video though.
@aleksandarivanov4554
@aleksandarivanov4554 2 жыл бұрын
This tutorial is helpful for Linux users too. Thank you.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Glad it was helpful!
@JimRohn-u8c
@JimRohn-u8c 5 ай бұрын
Can we also have a video for PostrgreSQL/Docker installation on Linux please?
@DatabaseStar
@DatabaseStar 5 ай бұрын
Good idea, but I don’t have any experience with using Linux. I imagine the process is similar.
@galaxy1066
@galaxy1066 Жыл бұрын
Simple and clearly, thank you very much.
@DatabaseStar
@DatabaseStar Жыл бұрын
You are welcome!
@dianaaycachi3834
@dianaaycachi3834 2 жыл бұрын
I am having this error: FATAL: password authentication failed for user "some-postgres". I have tried to uninstall postgres server. I am using windows. Help, please!
@DatabaseStar
@DatabaseStar 2 жыл бұрын
I am guessing that the command you're using isn't quite correct (perhaps it's wrong in my video too). The some-postgres is the container name, not the username. Perhaps there's a space or a quote in the wrong place. Which command are you running?
@marcinkida9306
@marcinkida9306 Жыл бұрын
Thank you so much for the video. It was very clear and useful :)
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks, glad you liked it!
@hackwithharsha
@hackwithharsha 2 жыл бұрын
00:03:42 Thank You some-progress is the name of container not the name of image… name of the image is postgres. Just sharing :)
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Ah thanks for the correction!
@elvenpath7
@elvenpath7 5 ай бұрын
awesome. thanks for saving our time.
@DatabaseStar
@DatabaseStar 5 ай бұрын
No problem!
@mattsavage3258
@mattsavage3258 2 жыл бұрын
Video makes some incorrect statements, one of which is that a Docker hub account is required to access images. That is false. A Docker hub account is required only for pushing images to it.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks for the info Matt! I wasn't aware that you didnt need a Docker Hub account.
@shoaibejaz9614
@shoaibejaz9614 2 жыл бұрын
Thnaks sir. You explained it very well and helped me a lot 👍👍
@DatabaseStar
@DatabaseStar 2 жыл бұрын
You're welcome!
@flaviorocha9804
@flaviorocha9804 Жыл бұрын
Very good explanation. Thank you very much.
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks, glad you liked it!
@lachinhasanli1880
@lachinhasanli1880 11 ай бұрын
Hello, thank you for the explanation, but I get this error: SQL Error [42P07]: ERROR: relation "cars" already exists even though I never created this table before and only select row() works fine. Everything else is just like that gives me an error. Could you please give me a solution?
@DatabaseStar
@DatabaseStar 11 ай бұрын
Hi, that error means that the table already exists when you try to create a table called "cars". What if you run: select * from cars? This may show you the data in the table, or just that the table exists. You can delete the table by running DROP TABLE cars;
@TorstigHjalmr
@TorstigHjalmr 2 жыл бұрын
All set up and running. I was hoping that I could add this to Google Cloud Run as a container but that doesn't guarantee the data. Can you suggest a cheap way of hosting the Docker Postgres database image that does guarantee that the data is kept? (thanks for the video)
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Great idea! There are several ways to host them online, but I can create some videos on doing this. I also have a video coming soon on using Docker volumes to save data permanently which could help.
@TorstigHjalmr
@TorstigHjalmr 2 жыл бұрын
@@DatabaseStar sorry, only just saw your reply. I wonder if you can persist the data using Cloud Run. Maybe in a VM? It would be nice to see something though :)
@samircolpasgonzalez5638
@samircolpasgonzalez5638 2 жыл бұрын
Thank you for the tutorial, very simple and helpful
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks, glad you liked it!
@pnaraliogullari6863
@pnaraliogullari6863 6 ай бұрын
I am grateful for this video. Thank you very much
@DatabaseStar
@DatabaseStar 6 ай бұрын
Thanks! Glad you like it.
@atakandurkal2400
@atakandurkal2400 3 ай бұрын
great instructions for istallin dadabase on docka
@DatabaseStar
@DatabaseStar 3 ай бұрын
Thanks!
@le0n0920
@le0n0920 2 жыл бұрын
What would be awesome is if you could do a video showing this with adding how to allow remote access to the psql db via configuring the pg_hba files when building it in docker. Other wise these vids are a dime a dozen...........dare excepted?
@DatabaseStar
@DatabaseStar 2 жыл бұрын
That sounds like a good idea for a video!
@torrvic1156
@torrvic1156 11 ай бұрын
Thank you sir! That was useful.
@DatabaseStar
@DatabaseStar 11 ай бұрын
Glad it was helpful!
@whiffwhaffwiz8851
@whiffwhaffwiz8851 2 жыл бұрын
01:30 You have just installed Docker Desktop. Why does Docker Desktop list 3 containers ? Have the images been downloaded and run automatically ?
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Good question. These containers are there as I had set up other containers before recording this video. When you install Docker Desktop fresh, there will be no containers in this list.
@shifthappens666
@shifthappens666 Жыл бұрын
I am really confused by the having to add -p and specifying the port only because when I was looking through the document in the docker hub site it was not there or did I miss it somehow?
@DatabaseStar
@DatabaseStar Жыл бұрын
I think you could get it working without specifying the port, as it may use a default. But if it doesn't work, try adding the port.
@shifthappens666
@shifthappens666 Жыл бұрын
@@DatabaseStar I understand that but I just wanted the document to have this. I am grateful for the video though. Thank you!
@sadeghFiroozandeh
@sadeghFiroozandeh Жыл бұрын
Hi, When running local Postgres in Docker, I encounter with this problem: Relation "X" does not exit Line 2 select * from ... What is the reason?
@DatabaseStar
@DatabaseStar Жыл бұрын
Hey, this error happens because the table "X" does not exist. A relation is another name for a table.
@sadeghFiroozandeh
@sadeghFiroozandeh Жыл бұрын
@@DatabaseStar TNX alot
@IM4fLEX
@IM4fLEX Жыл бұрын
Connection refused: Check that host name and port are correct and that the postmaster is accepting TCP/IP connections. I have postgres 14.9-alpine3.17 image is running as a container. At the end of the docker run command, I have given postgres:14.9-alpine3.17. Is this the problem?
@DatabaseStar
@DatabaseStar Жыл бұрын
I'm not sure if that's the problem. It should be working. Is the container running? Does the name match what you see in the list of docker images?
@IM4fLEX
@IM4fLEX Жыл бұрын
@@DatabaseStar Yes, The container was running and the name matched the docker image. I'm running Docker Toolbox on Windows 8, 64-bit processor. I have a doubt, What is the host name? We are trying to connect to the container yeah? so the host name maybe the same as docker container name? Is there a connection string option available?
@bassam.2023
@bassam.2023 2 жыл бұрын
Thanks! But will the data persist? How to make it so that the docker container will start upon reboot?
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Good questions! I don’t think the data will persist if you stop and start the container. There’s a concept called mounting which I think will allow data to be saved, but I haven’t looked into it. I will soon and make a video on it. Starting on reboot, I’m not sure how to do that either, but it’s a good idea and I’ll look into it
@aldodanielmendoza363
@aldodanielmendoza363 2 жыл бұрын
You can use a volume to persist your data With this command you create a volume named dbPostgres11 docker volume create dbPostgres11 Then you have to pass this volume to the docker container with flag --mount So. the command to run your progress is the next, I needed to install postgres11, so the :bullseye is just a tag to install that version, you can see this here: hub.docker.com/_/postgres The src is the volume and the destination is /var/lib/postresql because is a common location for PGDATA docker run --name postgress11 --mount src=dbPostgres1,dst=/var/lib/postgresql -p 5432:5432 -e POSTGRES_PASSWORD=root -d postgres:bullseye This persist my data, If you cannt see your tables and data in DBeaver, you have to refresh your connection with F5 or right click in connection name and select refresh.
@piyushpatil6874
@piyushpatil6874 3 ай бұрын
thank you sir , for such gold mines
@DatabaseStar
@DatabaseStar 3 ай бұрын
You're welcome!
@navalkumarshukla1839
@navalkumarshukla1839 Жыл бұрын
I don't get it, what's the need of the postgres container, if we have to connect to the actual database, like as I a developer I have to install Postgres anyway, so what's the use?
@DatabaseStar
@DatabaseStar Жыл бұрын
Good question. Containers have many benefits which I'm still looking into. They are helpful in the deployment process and can be created easily to help with testing.
@navalkumarshukla1839
@navalkumarshukla1839 Жыл бұрын
@@DatabaseStar should not it be like, I run a container, bind the port, and mount a volume (using -v flag) so as to persist the data... without installing the PostgreSQL.
@vijeandran
@vijeandran 2 жыл бұрын
Thanks for the video. How can I access local postgresql data from docker?
@DatabaseStar
@DatabaseStar 2 жыл бұрын
No problem! What do you mean by local postgresql data? Isn't the docker container running locally for you?
@vijeandran
@vijeandran 2 жыл бұрын
@@DatabaseStar Postgresql installed in my laptop. How can I access this Postgres database tables from a container?
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Ah thanks for clarifying. I'm not sure how to do that actually. I'm still learning about containers and Docker though.
@jucajata95
@jucajata95 Жыл бұрын
We can do the same with mysql, what's the difference between mysql workbench and dbeaver?
@DatabaseStar
@DatabaseStar Жыл бұрын
MySQL Workbench and dBeaver are both tools for working with SQL. The basic functionality between the two tools are the same. However, MySQL Workbench is just for MySQL databases, and DBeaver works on many databases including MySQL and Postgres.
@zahrasoltani8630
@zahrasoltani8630 Жыл бұрын
How can I check that my Postgres project is in the container? I already had a project in a database. I followed the tutorial and added the same password as my project when running the Postgres image. how to make sure it is run in the container?
@DatabaseStar
@DatabaseStar Жыл бұрын
What do you mean by Postgres project? Do you mean your tables and data, or something else?
@lolikpof
@lolikpof 9 ай бұрын
Do you have a video about persistent data for PostgreSQL?
@DatabaseStar
@DatabaseStar 9 ай бұрын
Do you mean persistent data using Docker? If so, I haven't created a video on that.
@lolikpof
@lolikpof 9 ай бұрын
@@DatabaseStar yeah, that's what I meant. I believe I've found out how to do it, but I don't know if this is even such a good idea in the first place, and if docker should be used in production. Currently I just have two containers, a base image, and a postgres image, and I use docker compose. But what happens, if the postgres image version gets updated? Will the persistent data (with volumes) still be correct? Anyway, would be cool if you made a video)
@mdfarhanhossan9968
@mdfarhanhossan9968 2 жыл бұрын
FATAL: password authentication failed for user "postgres". This error i am getting while test connection.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Hmm are you using the same password you had in the Docker run command?
@NFLStudy
@NFLStudy 2 жыл бұрын
I get the same error and I am sure password is correct.
@BlueCamper2000
@BlueCamper2000 2 жыл бұрын
How do you come to the UI at 7:22? I follow the previous steps but there isn't any UI opened
@DatabaseStar
@DatabaseStar 2 жыл бұрын
This is a program called DBeaver. It's a tool that is used to run SQL queries on many databases including PostgreSQL. Postgres comes with something called pgAdmin, but I didn't demo it because I have trouble using it (and many others have trouble as well). You can download dbeaver from their website, open it, and it looks like the UI in the video.
@abhiraj7913
@abhiraj7913 2 жыл бұрын
I have created a container but after creation, it automatically reaches the exit status. even I tried "docker start id" still unable to start them then please tell me how would I enter in bash terminal or how to start that container
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Are you getting an error message? I'm not sure what would be causing this issue. I think there's a way to see the logs in Docker which could give you more information.
@abhiraj7913
@abhiraj7913 2 жыл бұрын
whatever container I am creating is in a running state and I am able to stop or start that container manually. but when I create any container using Postgress then automatically it stops and shows exited 5 seconds ago in the status column. I use docker run container id, it runs successfully then again after 2-3 second when i enter docker ps then the container doesn't appear there. when i enter docker ps -a then it shows and written over there exited 5 seconds aga. kindly tell me the solution i am inthe middle of something. please provide me any other platform's link where i can share the photos to you and that helps me to get over it.
@divyanshusingh6473
@divyanshusingh6473 Жыл бұрын
how to mount volume, so that previous data if any can be restored/reused?
@DatabaseStar
@DatabaseStar Жыл бұрын
I've got another video here that discusses mounts in Docker: kzbin.info/www/bejne/Y6HdoaesmK-BnpI
@stephenunsure2943
@stephenunsure2943 Жыл бұрын
Great video thanks!
@DatabaseStar
@DatabaseStar Жыл бұрын
Glad you liked it!
@gencaypolat8901
@gencaypolat8901 2 жыл бұрын
Thank you sir, it is very beneficial video!
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Glad you like it!
@navodasenavirathne9084
@navodasenavirathne9084 2 жыл бұрын
This was really helpful.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Glad it helped!
@locster73
@locster73 2 жыл бұрын
Can you tell me how I can connect to the db from another host?
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Do you mean from a different computer? Or from a different IDE? If it's another computer I don't think it's possible because the Docker container is running on your computer. Maybe it is possible but I don't know how. If it's from another IDE on your computer, then you can enter the connection details into the connection screen in your IDE.
@hedforever8984
@hedforever8984 4 ай бұрын
how to find the url and use it for prisma database url
@DatabaseStar
@DatabaseStar 4 ай бұрын
I'm not sure how to use Prisma, but if you have Docker on your computer, could you use localhost?
@MisterForgettable
@MisterForgettable 2 жыл бұрын
Thanks for the video sir, it helped me ✨
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Glad it was helpful!
@_rachid
@_rachid 4 ай бұрын
Thank you.
@DatabaseStar
@DatabaseStar 4 ай бұрын
You’re welcome!
@likithalikku7478
@likithalikku7478 2 жыл бұрын
Can we connect postgres database to docker without DBeaver
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Yes you can, you can use any other IDE that supports Postgres (such as pgAdmin, Postico)
@prasannahiremath442
@prasannahiremath442 Жыл бұрын
What is the IDE you are using to connect to database ?
@DatabaseStar
@DatabaseStar Жыл бұрын
The IDE I use here is called DBeaver. But you can do the same thing with pgAdmin which comes with Postgres.
@prasannahiremath442
@prasannahiremath442 Жыл бұрын
@@DatabaseStar Thank you. I already have pgAdmin. However wanted to explore some multi-platform tool.
@PiyushGhosh-l4k
@PiyushGhosh-l4k 9 ай бұрын
I have my own application. I want to set my own password and while entrying i want databases that i have created . How can i do that ???
@DatabaseStar
@DatabaseStar 9 ай бұрын
I don’t think I understand. If you want to create a database you can do that within Postgres using a tool such as pgAdmin
@Nadiacahyanig
@Nadiacahyanig Жыл бұрын
Please make more videos so far you’re the only channel that explain in detail 🥲🥲🥲🥹🥹🥹
@DatabaseStar
@DatabaseStar Жыл бұрын
Thank you, I will!
@chaitanyaGudimalla
@chaitanyaGudimalla Жыл бұрын
5432 port is already in use what port should i use now?
@DatabaseStar
@DatabaseStar Жыл бұрын
You could use a slightly different port number such as 5433 or 5430
@chaitanyaGudimalla
@chaitanyaGudimalla Жыл бұрын
@@DatabaseStar Thank you for the quick response!
@akbarkhusnazarov1056
@akbarkhusnazarov1056 2 жыл бұрын
thank you for the lesson))
@DatabaseStar
@DatabaseStar 2 жыл бұрын
You're welcome.
@niyazibakkal196
@niyazibakkal196 2 жыл бұрын
Thank you for sharing🙂
@DatabaseStar
@DatabaseStar 2 жыл бұрын
No problem!
@pappyodanial
@pappyodanial 2 жыл бұрын
Connection refused. It's running. I checked user name and password twice.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
What happens when you run the command "docker ps"? Is the container running? If so, then perhaps a Google search for the error, or checking the docker logs (I think there's a command for seeing docker logs)
@oseiacheampongderrick9960
@oseiacheampongderrick9960 2 жыл бұрын
it worked perfectly.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Awesome!
@semihatalay865
@semihatalay865 2 жыл бұрын
Thank you so much.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Glad you like it!
@PlusTres
@PlusTres 2 жыл бұрын
how to connect metabase inside docker to postgres?
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Metabase inside docker? I'm not sure as I don't have any experience with that.
@yogeshbl9848
@yogeshbl9848 Жыл бұрын
why can't I find anyone using postgres from a kubernetes pod?
@DatabaseStar
@DatabaseStar Жыл бұрын
I'm not sure, actually!
@yogeshbl9848
@yogeshbl9848 Жыл бұрын
@@DatabaseStar do you know how to?
@DatabaseStar
@DatabaseStar Жыл бұрын
No idea, unfortunately. I've never used Kubernetes...
@8982121541
@8982121541 2 жыл бұрын
Hi is there any way by which i can literally pass a secret password so that nobody can know the password while doing docker create
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Hmm I'm not sure. There may be a way to use environment variables or some kind of configuration file, but I'm not sure.
@alphaamadoudiallo1679
@alphaamadoudiallo1679 9 ай бұрын
Thank you, my best investment today
@DatabaseStar
@DatabaseStar 9 ай бұрын
Excellent!
@Giorgi.Japiashvili
@Giorgi.Japiashvili Жыл бұрын
You don't need a docker hub account for tired
@DatabaseStar
@DatabaseStar Жыл бұрын
That’s true. I think I either misunderstood the error message I was getting when I did this, or it has changed since then.
@oussamasethoum2755
@oussamasethoum2755 2 жыл бұрын
Thank you man
@DatabaseStar
@DatabaseStar 2 жыл бұрын
No problem!
@ДеянЦонев-ы7в
@ДеянЦонев-ы7в 2 жыл бұрын
I get FATAL: password authentication failed for user
@DatabaseStar
@DatabaseStar 2 жыл бұрын
I am guessing the password you entered is incorrect. Is it the same one you used when you set up the container earlier in the video?
@NFLStudy
@NFLStudy 2 жыл бұрын
I get the same error and I am sure password is correct.
@piyush.sltn4
@piyush.sltn4 2 жыл бұрын
Its giving me same error as well. I had one DB instance running but I closed that still getting that error. Please guide.
@agilbashirov6155
@agilbashirov6155 2 жыл бұрын
FATAL: password authentication failed for user "postgres"
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Does the password you enter match the one from the Docker run command?
@agilbashirov6155
@agilbashirov6155 2 жыл бұрын
@@DatabaseStar Absolutely, Yes.
@franksinatra4436
@franksinatra4436 2 жыл бұрын
thanks mate
@DatabaseStar
@DatabaseStar 2 жыл бұрын
You’re welcome!
@user16242
@user16242 Жыл бұрын
Clear!
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks!
@melihkeskin2381
@melihkeskin2381 2 жыл бұрын
merci 👍
@DatabaseStar
@DatabaseStar 2 жыл бұрын
You're welcome!
@emreaka3965
@emreaka3965 Жыл бұрын
Thanks :)
@DatabaseStar
@DatabaseStar Жыл бұрын
You're welcome
@xiscohernandezbibiloni8671
@xiscohernandezbibiloni8671 Жыл бұрын
says the database postgres not exist
@DatabaseStar
@DatabaseStar Жыл бұрын
Oh that’s odd. Perhaps the database no longer comes with the image.
@xiscohernandezbibiloni8671
@xiscohernandezbibiloni8671 Жыл бұрын
@@DatabaseStar The error is that in the host i already have a postgres after unistaled docker works fine.
@mtfilm8323
@mtfilm8323 5 ай бұрын
thank sir
@DatabaseStar
@DatabaseStar 5 ай бұрын
You're welcome!
@LiviaLeiteSilva
@LiviaLeiteSilva 9 ай бұрын
god bless you 🙏🙏
@DatabaseStar
@DatabaseStar 9 ай бұрын
Thanks!
@mstgnz
@mstgnz 3 жыл бұрын
FATAL: role "postgres" does not exist
@DatabaseStar
@DatabaseStar 3 жыл бұрын
Which command did you run to get this error?
@mstgnz
@mstgnz 3 жыл бұрын
@@DatabaseStar 5432:5432 not working for mac m1, but working to 5433:5432 different port expose.
@murataydn7161
@murataydn7161 2 жыл бұрын
hocam problemi nasil cozdunuz yada cozebildiniz mi m1 kullaniyorum 2 gundur postgres de problem yasiyorum
@Viru2604
@Viru2604 2 жыл бұрын
@@mstgnz Same here
@oscarmejia8306
@oscarmejia8306 2 жыл бұрын
god speed
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks!
@lodimateus
@lodimateus Жыл бұрын
nice voice and video ahahhaha
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks!
@johanrocheteau4873
@johanrocheteau4873 2 жыл бұрын
Thanks for this video. I have an error : Network error Motif: Network unavailable: javax.net.ssl.SSLHandshakeException:Remote host terminated the handshake I can't find how to solve this error. Thanks for your help.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Hmm that is odd. I haven't seen that error before unfortunately. Do you have any other Postgres databases running on your computer?
@wiszkyhow
@wiszkyhow 2 жыл бұрын
can we connect it with postgress url ? like this postgres://username:password@host:5432/DBname
@DatabaseStar
@DatabaseStar 2 жыл бұрын
I think so but I haven't tried it. The database will be running on localhost so this should work.
@markhopgood660
@markhopgood660 2 жыл бұрын
This command helped me, thank you.. docker run --name some-postgres -p 5432:5432 -e POSTGRES_PASSWORD=mysecretpassword -d postgres
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Good to know!
@torrvic1156
@torrvic1156 11 ай бұрын
Me too!
@udeoguarthurtobechukwu2457
@udeoguarthurtobechukwu2457 2 жыл бұрын
$ docker run --name some-postgres -p 5432:5432 -e POSTGRES_PASSWORD=mysecretpassword -d postgres I Keep getting the error message ; zsh: command not found: $ when i enter the above in my terminal? please help @database star
@DatabaseStar
@DatabaseStar 2 жыл бұрын
I think that means the Docker command is not recognised. Has docker been installed? If so, I would suggest looking up how to add the Docker command to your “bash profile”
@RD-vj3fh
@RD-vj3fh Жыл бұрын
Remove the $ at the beginning of your command, then the problem will be fixed.
@husseinfarah3519
@husseinfarah3519 Жыл бұрын
when I was trying to demonstrate the tutorial using DBeaver Comunity especially for testing the database connection, I faced this error below picture " The connection attempt failed. EOFException java.io.EOFException", Sir if you can help me
@DatabaseStar
@DatabaseStar Жыл бұрын
I’m not sure what would be causing this issue, the message doesn’t say much
@priyanshiagarwal5852
@priyanshiagarwal5852 2 жыл бұрын
How to add postgis with postgresql in docker
@DatabaseStar
@DatabaseStar 2 жыл бұрын
I'm not sure actually...
Docker Crash Course for Absolute Beginners [NEW]
1:07:39
TechWorld with Nana
Рет қаралды 1,8 МЛН
MAGIC TIME ​⁠@Whoispelagheya
00:28
MasomkaMagic
Рет қаралды 17 МЛН
Yay, My Dad Is a Vending Machine! 🛍️😆 #funny #prank #comedy
00:17
бабл ти гель для душа // Eva mash
01:00
EVA mash
Рет қаралды 3,9 МЛН
Will A Basketball Boat Hold My Weight?
00:30
MrBeast
Рет қаралды 126 МЛН
Run Postgres in a Docker Container (Easiest PostgreSQL Setup)
12:23
How to Set Up MySQL Database with Docker
10:14
Database Star
Рет қаралды 197 М.
The intro to Docker I wish I had when I started
18:27
typecraft
Рет қаралды 191 М.
How to Save Docker Data using Bind Mounts or Volumes
13:41
Database Star
Рет қаралды 31 М.
Docker and PostgreSQL in [10 Minutes]
21:06
Amigoscode
Рет қаралды 271 М.
Build a CRUD API with Docker Node.JS Express.JS & PostgreSQL
26:02
How to Set Up MySQL Database with Docker (2024)
22:54
ProgrammingKnowledge
Рет қаралды 7 М.
How to Set Up MySQL Database with Docker
16:46
Abstract programmer
Рет қаралды 40 М.
MAGIC TIME ​⁠@Whoispelagheya
00:28
MasomkaMagic
Рет қаралды 17 МЛН