How to Set Up a PostgreSQL Database with Docker

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 พ.ย. 2024

ความคิดเห็น • 236

  • @fernandozuniga6590
    @fernandozuniga6590 15 ชั่วโมงที่ผ่านมา

    Thank you. This is how all tutorials should be made: Short, Clear instructions to follow, To the point. Simplicity is so beautiful but hard to find.

  • @imransadiq5851
    @imransadiq5851 2 ปีที่แล้ว +29

    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.

  • @ishayfrenkelYT
    @ishayfrenkelYT ปีที่แล้ว +15

    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  ปีที่แล้ว +2

      Thanks, glad it helped! Yeah I found many of the other Docker tutorials weren't that helpful.

    • @pongstr
      @pongstr 9 หลายเดือนก่อน +1

      this video is practically reading a readme with extra steps

    • @esmaelmohamed8209
      @esmaelmohamed8209 3 หลายเดือนก่อน

      All is true for me also!

  • @JeffreyMRose
    @JeffreyMRose 2 ปีที่แล้ว +9

    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 ปีที่แล้ว +1

      Good point, yea you are right they are different. Thanks for mentioning it here for others to notice too.

  • @jlacerd4
    @jlacerd4 ปีที่แล้ว +3

    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  ปีที่แล้ว +1

      No problem, I’m glad it helped you!

  • @rodrigobaiao3420
    @rodrigobaiao3420 10 หลายเดือนก่อน +1

    This is the BEST tutorial I've ever seen!!!!

    • @DatabaseStar
      @DatabaseStar  10 หลายเดือนก่อน

      Thanks! Glad you like it

  • @asfasdfsd8476
    @asfasdfsd8476 2 ปีที่แล้ว +30

    for anyone having error: FATAL: password authentication failed for user "postgres" - uninstall postgres server on your main OS, it blocks port

    • @DatabaseStar
      @DatabaseStar  2 ปีที่แล้ว +4

      Thanks for sharing, I think I’ve had that same error before too.

    • @NikGoodrich
      @NikGoodrich ปีที่แล้ว +1

      @@DatabaseStar Can you pin this? Our whole class had this problem from another Postgres lesson

    • @JoshuaNeedham
      @JoshuaNeedham ปีที่แล้ว +1

      Wouldn't setting a different port be a better option here? Seems excessive to remove postures from your hd.

    • @collinsnnadozie5092
      @collinsnnadozie5092 9 หลายเดือนก่อน +8

      U can use another new port by mapping it
      -p 5431:5432

    • @sahilgarg94
      @sahilgarg94 8 หลายเดือนก่อน

      @@collinsnnadozie5092 this must be pinned

  • @amanjang7531
    @amanjang7531 3 ปีที่แล้ว +10

    Thank you for explaining this better, and more succinctly than my college materials 🤝 👍

  • @easilyCoded
    @easilyCoded ปีที่แล้ว +15

    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  ปีที่แล้ว +1

      Awesome, thanks for the tip and solution!

    • @mauriciocantu9373
      @mauriciocantu9373 ปีที่แล้ว +1

      I love you so much, marry me

    • @tahirmahmudzade6386
      @tahirmahmudzade6386 ปีที่แล้ว +1

      Wouldn't simply changing port help?

    • @Jjr.001
      @Jjr.001 4 หลายเดือนก่อน +1

      thanks a lot

    • @vii2903
      @vii2903 2 หลายเดือนก่อน +1

      thank you so much! i was stressed out looking for an error that doesn't exist

  • @ramiworkstation
    @ramiworkstation 4 หลายเดือนก่อน +1

    This lesson is as sweet as Sugar. 🍬🍬Thank you for sharing

    • @DatabaseStar
      @DatabaseStar  4 หลายเดือนก่อน

      You’re welcome!

  • @MBinDenver
    @MBinDenver 5 หลายเดือนก่อน +1

    Thank you for this! Extremely easy given your tutorial...

    • @DatabaseStar
      @DatabaseStar  5 หลายเดือนก่อน

      You're very welcome!

  • @emirkaancati5218
    @emirkaancati5218 ปีที่แล้ว +1

    That was a really simple and instructive video. Thanks.

  • @XenidRol
    @XenidRol ปีที่แล้ว

    Thank you for that elaborate and concise explanation!

    • @DatabaseStar
      @DatabaseStar  ปีที่แล้ว

      Thanks! Glad it was helpful!

  • @sandeepgamot4585
    @sandeepgamot4585 3 ปีที่แล้ว +5

    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 ปีที่แล้ว +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.

  • @elvenpath7
    @elvenpath7 5 หลายเดือนก่อน +1

    awesome. thanks for saving our time.

  • @БоряДикий
    @БоряДикий 6 หลายเดือนก่อน +1

    great video, thank you for such an easy explanation!

    • @DatabaseStar
      @DatabaseStar  6 หลายเดือนก่อน

      You're very welcome!

  • @anurag3487
    @anurag3487 7 หลายเดือนก่อน

    great video, crisp and clear

  • @marioandresheviacavieres1923
    @marioandresheviacavieres1923 11 หลายเดือนก่อน

    Excellent explanations. Thanks a lot for the clarity. From now I'm a new of your channel followers.
    Thanks a lot Ben!

    • @DatabaseStar
      @DatabaseStar  11 หลายเดือนก่อน

      Awesome, thank you!

  • @ShafiqNazrin
    @ShafiqNazrin ปีที่แล้ว

    You really helped me test the connection by making the video. Thanks man

  • @piyushpatil6874
    @piyushpatil6874 4 หลายเดือนก่อน +1

    thank you sir , for such gold mines

    • @DatabaseStar
      @DatabaseStar  4 หลายเดือนก่อน

      You're welcome!

  • @yusiff
    @yusiff ปีที่แล้ว +1

    I love the way you explain, thanks a lot!

  • @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.

  • @aleksandarivanov4554
    @aleksandarivanov4554 2 ปีที่แล้ว +1

    This tutorial is helpful for Linux users too. Thank you.

  • @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

  • @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.

  • @flaviorocha9804
    @flaviorocha9804 ปีที่แล้ว

    Very good explanation. Thank you very much.

    • @DatabaseStar
      @DatabaseStar  ปีที่แล้ว

      Thanks, glad you liked it!

  • @torrvic1156
    @torrvic1156 11 หลายเดือนก่อน

    Thank you sir! That was useful.

    • @DatabaseStar
      @DatabaseStar  11 หลายเดือนก่อน +1

      Glad it was helpful!

  • @galaxy1066
    @galaxy1066 ปีที่แล้ว

    Simple and clearly, thank you very much.

  • @shoaibejaz9614
    @shoaibejaz9614 2 ปีที่แล้ว

    Thnaks sir. You explained it very well and helped me a lot 👍👍

  • @marcinkida9306
    @marcinkida9306 ปีที่แล้ว

    Thank you so much for the video. It was very clear and useful :)

    • @DatabaseStar
      @DatabaseStar  ปีที่แล้ว

      Thanks, glad you liked it!

  • @kimhongsieng6457
    @kimhongsieng6457 2 ปีที่แล้ว +1

    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.

  • @JimRohn-u8c
    @JimRohn-u8c 6 หลายเดือนก่อน +1

    Can we also have a video for PostrgreSQL/Docker installation on Linux please?

    • @DatabaseStar
      @DatabaseStar  5 หลายเดือนก่อน +1

      Good idea, but I don’t have any experience with using Linux. I imagine the process is similar.

  • @samircolpasgonzalez5638
    @samircolpasgonzalez5638 2 ปีที่แล้ว

    Thank you for the tutorial, very simple and helpful

    • @DatabaseStar
      @DatabaseStar  2 ปีที่แล้ว

      Thanks, glad you liked it!

  • @hackwithharsha
    @hackwithharsha 2 ปีที่แล้ว +1

    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 ปีที่แล้ว +1

      Ah thanks for the correction!

  • @mattsavage3258
    @mattsavage3258 2 ปีที่แล้ว +1

    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.

  • @gencaypolat8901
    @gencaypolat8901 2 ปีที่แล้ว

    Thank you sir, it is very beneficial video!

  • @navodasenavirathne9084
    @navodasenavirathne9084 2 ปีที่แล้ว

    This was really helpful.

  • @missman4264
    @missman4264 ปีที่แล้ว +2

    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.

  • @_rachid
    @_rachid 4 หลายเดือนก่อน

    Thank you.

    • @DatabaseStar
      @DatabaseStar  4 หลายเดือนก่อน

      You’re welcome!

  • @stephenunsure2943
    @stephenunsure2943 ปีที่แล้ว

    Great video 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!

  • @dianaaycachi3834
    @dianaaycachi3834 2 ปีที่แล้ว +1

    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?

  • @MisterForgettable
    @MisterForgettable 2 ปีที่แล้ว

    Thanks for the video sir, it helped me ✨

  • @alphaamadoudiallo1679
    @alphaamadoudiallo1679 10 หลายเดือนก่อน

    Thank you, my best investment today

  • @DatabaseStar
    @DatabaseStar  หลายเดือนก่อน

    Get your FREE cheat sheet of Docker commands: www.databasestar.com/docker-database-cheat-sheet/?

  • @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 ปีที่แล้ว +1

      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 :)

  • @Nadiacahyanig
    @Nadiacahyanig ปีที่แล้ว

    Please make more videos so far you’re the only channel that explain in detail 🥲🥲🥲🥹🥹🥹

  • @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.

  • @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

  • @oseiacheampongderrick9960
    @oseiacheampongderrick9960 2 ปีที่แล้ว

    it worked perfectly.

  • @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!

  • @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 ปีที่แล้ว +1

    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.

  • @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  ปีที่แล้ว +1

      Hey, this error happens because the table "X" does not exist. A relation is another name for a table.

    • @sadeghFiroozandeh
      @sadeghFiroozandeh ปีที่แล้ว

      @@DatabaseStar TNX alot

  • @niyazibakkal196
    @niyazibakkal196 2 ปีที่แล้ว

    Thank you for sharing🙂

  • @vijeandran
    @vijeandran 2 ปีที่แล้ว

    Thanks for the video. How can I access local postgresql data from docker?

    • @DatabaseStar
      @DatabaseStar  2 ปีที่แล้ว +1

      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 ปีที่แล้ว +1

      Ah thanks for clarifying. I'm not sure how to do that actually. I'm still learning about containers and Docker though.

  • @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?

  • @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?

  • @akbarkhusnazarov1056
    @akbarkhusnazarov1056 2 ปีที่แล้ว

    thank you for the lesson))

  • @mdfarhanhossan9968
    @mdfarhanhossan9968 2 ปีที่แล้ว +1

    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.

  • @lolikpof
    @lolikpof 10 หลายเดือนก่อน

    Do you have a video about persistent data for PostgreSQL?

    • @DatabaseStar
      @DatabaseStar  10 หลายเดือนก่อน

      Do you mean persistent data using Docker? If so, I haven't created a video on that.

    • @lolikpof
      @lolikpof 10 หลายเดือนก่อน

      @@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)

  • @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: th-cam.com/video/-pzptvcJNh0/w-d-xo.html

  • @markhopgood660
    @markhopgood660 2 ปีที่แล้ว +1

    This command helped me, thank you..
    docker run --name some-postgres -p 5432:5432 -e POSTGRES_PASSWORD=mysecretpassword -d postgres

  • @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.

  • @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.

  • @semihatalay865
    @semihatalay865 2 ปีที่แล้ว

    Thank you so much.

  • @PiyushGhosh-l4k
    @PiyushGhosh-l4k 10 หลายเดือนก่อน

    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  10 หลายเดือนก่อน

      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

  • @likithalikku7478
    @likithalikku7478 2 ปีที่แล้ว

    Can we connect postgres database to docker without DBeaver

    • @DatabaseStar
      @DatabaseStar  2 ปีที่แล้ว +1

      Yes you can, you can use any other IDE that supports Postgres (such as pgAdmin, Postico)

  • @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)

  • @prasannahiremath442
    @prasannahiremath442 ปีที่แล้ว

    What is the IDE you are using to connect to database ?

    • @DatabaseStar
      @DatabaseStar  ปีที่แล้ว +1

      The IDE I use here is called DBeaver. But you can do the same thing with pgAdmin which comes with Postgres.

    • @prasannahiremath442
      @prasannahiremath442 ปีที่แล้ว +1

      @@DatabaseStar Thank you. I already have pgAdmin. However wanted to explore some multi-platform tool.

  • @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.

  • @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...

  • @oussamasethoum2755
    @oussamasethoum2755 2 ปีที่แล้ว

    Thank you man

  • @chaitanyaGudimalla
    @chaitanyaGudimalla ปีที่แล้ว

    5432 port is already in use what port should i use now?

    • @DatabaseStar
      @DatabaseStar  ปีที่แล้ว +1

      You could use a slightly different port number such as 5433 or 5430

    • @chaitanyaGudimalla
      @chaitanyaGudimalla ปีที่แล้ว

      @@DatabaseStar Thank you for the quick response!

  • @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.

  • @priyanshiagarwal5852
    @priyanshiagarwal5852 3 ปีที่แล้ว

    How to add postgis with postgresql in docker

    • @DatabaseStar
      @DatabaseStar  3 ปีที่แล้ว

      I'm not sure actually...

  • @user16242
    @user16242 ปีที่แล้ว

    Clear!

  • @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.

  • @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.

  • @ДеянЦонев-ы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.

  • @franksinatra4436
    @franksinatra4436 2 ปีที่แล้ว

    thanks mate

  • @emreaka3965
    @emreaka3965 2 ปีที่แล้ว

    Thanks :)

  • @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.

  • @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.

  • @LiviaLeiteSilva
    @LiviaLeiteSilva 10 หลายเดือนก่อน

    god bless you 🙏🙏

  • @mtfilm8323
    @mtfilm8323 6 หลายเดือนก่อน

    thank sir

    • @DatabaseStar
      @DatabaseStar  6 หลายเดือนก่อน

      You're welcome!

  • @melihkeskin2381
    @melihkeskin2381 2 ปีที่แล้ว +1

    merci 👍

  • @mstgnz
    @mstgnz 3 ปีที่แล้ว

    FATAL: role "postgres" does not exist

    • @DatabaseStar
      @DatabaseStar  3 ปีที่แล้ว

      Which command did you run to get this error?

    • @mstgnz
      @mstgnz 3 ปีที่แล้ว +2

      @@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

  • @lodimateus
    @lodimateus ปีที่แล้ว +1

    nice voice and video ahahhaha

  • @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.

  • @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.

  • @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;

  • @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.