Spin up a Postgres Instance & PGADMIN with Docker

Key Takeaways

you're gonna open your the terminal window and zoom in a little bit here so you can see and then that terminal window I'm gonna write docker run and then I want to write phosphorous so these are the three words that you need in order to spin up Postgres in stow container that will download them as you'll need an internet connection to download them is for the first time I have the image already done right so it's gonna be faster than you're probably right so you can do that and it will run but before I want to do that I want actually since Postgres is a database right if you want to listen to a port right bhaskar's listen by default in port 4 5 4 3 2 right and in order to listen to that port you need to actually expose that poor to your host ok and in order to do that you will use the /b 4 port ok and then I'm gonna expose the same exact port 5 4 3 2 that's my host port and that's the container port right this is like kind of a mapping so this means that hey when you when you spin up a docker container it will spin up on this port right five four three two all the time right but what pour do you want to map it in the the host which is my machine which is my Mac in this case right and for font I am going to give this container a name you don't have to is gonna assign it a random name like sleazy Joe whatever right but I'm gonna give it and really name I'm just like called PG okay and that's hit enter let's see what happens mmm and database is ready and to accept connections how simple and cool is that guys right this is really cool right in your case it might take slightly more time the reason is problems it's gonna download image do all that stuff obviously we don't have a way to test that database right unless we write some code but to do that I'm gonna spin up another docker container that have PG admin and if you're familiar with Postgres PG admin is actually the administrator interface that administer if you will the Postgres databases and it's a whoop server essentially so again lessons to a port and to do that it's gonna be like a mini web server listening to a port will have a web application that manages nicely lit manages your Postgres database so let's go ahead and spin up a door a post Chris no PG admin ok PG admin is managed by the David page right that's the official that's the that's the official report that I found actually and to do that again docker run only if I can spell doctor right and since obviously we're gonna spin it in on port PJ I mean this is the knowledge right you have to know PG admin runs on port 80 that particular image that we're gonna run apart runs on first 80 so I can map it to port 80 right but I don't want to do that because port it is already in use here I'm using it for nginx so I'm gonna just literally any other port right I'm gonna use five five five five yeah and after we do that another requirement here is let's write the name of the container PG admin again this this part is completely optional but it's cool to have like so you can do docker start PG admin docker stop pretty admin like yeah that's it's cool to have a name for your container otherwise you get a sleazy Jo sleazy Arthur whatever okay the name of the image is deep age PG item four okay that is almost we're almost there okay so we have dr. Ron right we have the poor roots five five five mapping to port 80 we have the name and we have the D page /pg Edmond for what we need to do is actually the requirement is since it's a webserver since it's a it's actually an application so there is a credential default credential there are obviously you have to put this default credential as an environment variable and to do that you're gonna use /e not / - e as an environment variable when the environment variable in this case is literally PG admin underscore default underscore we are our line underscore email okay and although says email you don't have to have an email just like I'm gonna name it Hossein that works right it's it's no really it doesn't have to be an email per se and then I'm gonna add another environment variable - you have to do that and then PG admin underscore default underscore password okay hopefully easy to remember my password is so secure it's called [Applause] okay and I think that is all we need and then just like that we are running on port five five five five mapping to port 80 and let's okay so now I have Postgres running and I have PG admin running so how to disappear since it's our web application your browser is your friend right unfortunately you cannot hit the the Postgres database directly from the browser right because it's TCP so I'm gonna do Hussein Mac that's my machine name and then guess what was five five five five and just like that we're gonna be prompted with the email and password which was the environment variable where we provided which was retracted just Hussein and the infamous password and then login we have a blank slate of nothingness right we have the beautiful beach Edmond we don't have any servers so how can we connect to our if only we have a database that we can't connect to oh we actually do sir we do where is it listening it's listening on port five four three two I can change that by the way right we're gonna show you in a minute that's the beauty of this we're gonna spin up another database on our report but let's add the first one first I'm gonna name this my DB one okay let's go yeah my my PG DP docker whatever you can't call whatever you want this is just a name the host the host is Jose Mac that's the machine name right and the port is happen to be the same five four three two remember we mapped five four three two two five five four three two and the default password is Postgres and Postgres okay and then you go ahead and you connected and then you can do all sorts of cool things by default posting export squares you can start creating it database right do you be I just created database why not you can create tables and all sort of cool things that's great another instance guys before we end this video so I'm gonna do doc Iran uh - P 543 one really mapping - five four three two which is the port that is the database port right that Postgres database board and I am going to name it PG to the instance - and I Postgres I think that said I think that's it that will spin up another database how simple is that guys if you if you if you do not use your containers you have to install it twice there is no way you can install well I'm lying you can actually install two Postgres in the same machine we have to configure for them different port but it's it's really really tedious right but this you can just stop a container start on another containers you're so simple right so I'm gonna create another server docker - what's the host name same host name but the port is five four three one can i connect sir can i connect oh we are connected right it's a blank slate there is not a single day there's once database right and the other one has two database [Music]