How to create a docker-compose setup with PostgreSQL and pgAdmin4

In this video, I showcase and explain how our docker-compose file creates our PostgreSQL database and a pgAdmin dashboard. It is then shown how we can connect our PostgreSQL database from our docker container to the pgAdmin dashboard running in another container.

Welcome to my programming and software engineering channel! Here, you'll find a variety of videos on topics such as Java, Python and Docker. Whether you're a beginner looking to learn a new language or an experienced developer looking to stay up-to-date with the latest trends, my channel has something for everyone. Join me on this journey and let's learn together!

[danieltorres]

Whenever I have to see how to connect pgadmin to my containers I always return to this tutorial, thank you very much

[viktoraka]

Thank you very much for this, you saved a life

[Akhmad_Dag]

My brother, thank you very much for your help. I couldn't find the information I needed all over the Internet. You helped me

[abdulqahar]

Works well, thank you for your time and effort.

[StudyStreamPlus]

Thank you for this. Worked first time. I don't like the idea of having an additional container just for a database GUI, however it is simpler than modifying the postgres config on build to dynamically add a host ip.

Do you know how we can persist the connection in pgAdmin so we don't have to set it up every time?

[HriSri]

thanks this is exactly what i wanted to use

[ricardo]

May I ask if you can have a similar docker compose demo using postgreSQL and Liquibase ?

[henoknigatu]

👍very helpful video...but the ipaddress for the postgres db is not static when i restart the container it changes, is there any way i can fix this, i wanted my locally deployed webapp to access the db when ever i start my server.

[WorldKris]

Hi. Thank you so much for the guide! If I may ask, how did you end up typing that "version:3.8"? Should I input the same line of code as well if I'm going to install PostgreSQL and Pgadmin4 via Docker as of the time of this writing?

[Maximilian.R.L]

Does the host or other container running web server? I cannot connect to either service pgadmin-client or browser from other device

[mikehynz]

I'm new to PG and actually SQL in general in the middle of some courses (for clarity). I really would like to use a Docker setup PG, will this be similar on mac osx?

[alaatahraoui]

thank you for the explanation and the video, pls i have some questions:
1- why do we use the ip of the container while we can use our host machit ip adresse?
2- does the ip adresse of the container fixed or it can be changed?
Thank you in advance.

[kresimircosic]

I don't have the IP address filled at all, just an empty string "".

EDIT: NVM it wasn't started at all for some reason.

[ronsreacts]

Today i got to know to be intelligent, you first need to be a foolish.