Thank you for this video. I tried troubleshooting via Chat GPT and Stackoverflow, but how do I get past this error at 4:40 when I click Save: unable to connect to server: connection failed: connection to server at , port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections?
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?
👍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.
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?
Docker running locally is only accessible from your own machine on localhost. If you want something to be publicly available, the simplest way is to use a cloud hosting provider like AWS or Google Cloud.
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.
1. How we can access our container depends on our position. From the same docker network we can just use the container name. From our local machine where we port forward an open port from our container we need to use localhost and the port. 2. It depends on your setup. But as far as I remember it will not always stay the same. 3. You might be right in the assumption that it will work with a container name instead of IP in this case, let me know if you test it.
1. How does my pgadmin and postgres communicate even without specifying network? this is absurd! 2. How come data is stored and volumes are implicitly created for postgres?
While I love this tutorial, I was wondering why after I previously set this up, then close the container (docker-compose down) , and then come back with docker-compose up, it didn't save my server or any tables I previously created?
Ah! I see, data persists as long as the container is running, duh! Lol I have to leave the container running, but you can sign out and sign in as much as you want I guess, sorry, I'm a novice.
No problem at all! You're right-data persists as long as the container is running, so you'll need to keep it up to retain your server and tables. Feel free to sign out and in as needed, and don't hesitate to ask more questions!
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?
Yes, the process should be similar on macOS as well. You can follow the same steps in the tutorial to set up PGAdmin in a Docker container on macOS. Good luck with your courses!
Thanks for the assisting me to connect my PGadmin with Postgres in Docker container. It was a big challenge for me.
Glad it helped!
Whenever I have to see how to connect pgadmin to my containers I always return to this tutorial, thank you very much
Glad to hear that!!
So true bro, I've always used this guide - Saved my live multiple times. We love you Random Code !!!!!
My brother, thank you very much for your help. I couldn't find the information I needed all over the Internet. You helped me
Thank you very much for this, you saved a life
Thank you so much for this tutorial, I saw lot of the other tutorials but this one really helped me to solve the problem.
Great to hear!
Works well, thank you for your time and effort.
Glad it helped
Thank you for this video. I tried troubleshooting via Chat GPT and Stackoverflow, but how do I get past this error at 4:40 when I click Save: unable to connect to server: connection failed: connection to server at , port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections?
GOD BLESS AND PROTECT YOU FROM ALL HACKERS BRO.!!!!
Thanks my friend, excellent tutorial, hello from Brazil :)
Thank you! Cheers!
Thank you! The PostgreSQL and Pg Admin are up. The "version" line of the docker-compose.yml file seems to have been deprecated.
You are very much right, the version line is no longer needed in newer versions, but it won't break if you still include it.
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?
what version above? compose version?
May I ask if you can have a similar docker compose demo using postgreSQL and Liquibase ?
👍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.
saved my life, thank you
Thank you so much! I’m really glad to hear that I was able to save your life :)
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?
The newer versions of Docker Compose no longer need this line, and I think everything should work the same without it.
@@Randomcode_0 thank you for the insight :)!
u save my life bro
Thank you for this!
Does the host or other container running web server? I cannot connect to either service pgadmin-client or browser from other device
Docker running locally is only accessible from your own machine on localhost. If you want something to be publicly available, the simplest way is to use a cloud hosting provider like AWS or Google Cloud.
thanks this is exactly what i wanted to use
Great!
Thanks a lot!!!!!. It works perfectly.
Glad it helped
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.
1. How we can access our container depends on our position. From the same docker network we can just use the container name. From our local machine where we port forward an open port from our container we need to use localhost and the port.
2. It depends on your setup. But as far as I remember it will not always stay the same.
3. You might be right in the assumption that it will work with a container name instead of IP in this case, let me know if you test it.
thank you for your answer. I tried with the name of the container (postgres_container) in pgAdmin and it works with no problem@@Randomcode_0
godbless to you sir
1. How does my pgadmin and postgres communicate even without specifying network? this is absurd!
2. How come data is stored and volumes are implicitly created for postgres?
While I love this tutorial, I was wondering why after I previously set this up, then close the container (docker-compose down) , and then come back with docker-compose up, it didn't save my server or any tables I previously created?
Ah! I see, data persists as long as the container is running, duh! Lol I have to leave the container running, but you can sign out and sign in as much as you want I guess, sorry, I'm a novice.
No problem at all! You're right-data persists as long as the container is running, so you'll need to keep it up to retain your server and tables. Feel free to sign out and in as needed, and don't hesitate to ask more questions!
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?
Yes, the process should be similar on macOS as well. You can follow the same steps in the tutorial to set up PGAdmin in a Docker container on macOS. Good luck with your courses!
@@Randomcode_0 Thanks for the help! Worked great!
for me using the gateway IP address did the trick.
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.
up
🔥🔥🔥
thank you
Good
Thanks
thanks :)
Happy to help
save me. thanks man
Happy to help
Today i got to know to be intelligent, you first need to be a foolish.
Tried. Woks !!
Thanks