{"id":160,"date":"2022-02-10T12:49:35","date_gmt":"2022-02-10T12:49:35","guid":{"rendered":"https:\/\/tejasgarde.dev\/?p=160"},"modified":"2022-02-10T12:49:36","modified_gmt":"2022-02-10T12:49:36","slug":"postgres-database-and-pg-admin-using-docker-compose","status":"publish","type":"post","link":"https:\/\/tejasgarde.dev\/index.php\/2022\/02\/10\/postgres-database-and-pg-admin-using-docker-compose\/","title":{"rendered":"Postgres Database and PG Admin using Docker Compose"},"content":{"rendered":"\n

Docker makes all development things really easy. Just one line command and you are up with whatever you want (of course if it’s available as docker Image \ud83d\ude09). <\/p>\n\n\n\n

Gone are those days when you have to spend hour or so to setup just a simple database on you local development environment , worrying about process , ports etc. Docker makes it really easy for you . In this article we will use a simple docker compose file to setup the PostgreSQL data base as well as PG Admin. <\/p>\n\n\n\n

Here is the docker compose file to set it up. Save this code as docker-compose.yaml<\/p>\n\n\n\n

version: \"3\"\nservices:\n  db:\n    container_name: my-pg-db\n    image: postgres:13.4-buster\n    restart: always\n    environment:\n      POSTGRES_USER: pguser\n      POSTGRES_PASSWORD: pgpassword\n      POSTGRES_DB: mydatabase\n    ports:\n      - \"5432:5432\"\n    volumes:  # Persist the db data\n      - database-data:\/var\/lib\/postgresql\/data\n  pgadmin:\n    container_name: my-pgadmin\n    image: dpage\/pgadmin4\n    restart: always\n    environment:\n      PGADMIN_DEFAULT_EMAIL: mypg@example.com\n      PGADMIN_DEFAULT_PASSWORD: Hello123\n    ports:\n      - \"9080:80\"\nvolumes:\n  database-data:<\/code><\/pre>\n\n\n\n
To run this docker container go to the folder in which it is saved and type the following command <\/p>\n\n\n\n
$ docker-compose up<\/code><\/pre>\n\n\n\n
The above command will run 2 docker containers , one is postgres db container my-pg-db and other one is PG Admin container my-pgadmin.  You can check these with docker ps command . Now as the PG Admin container is running at port 9080 got to http:\/\/localhost:9080 , you should see page like this.  <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Here you have to login with credentials given in my-pgadmin container .  One login you will have to add server from left side<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
In create Server page , in general section provide any name <\/p>\n\n\n\n
In Connection Tab as shown you will have to provide IP address of the my-pg-db container. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
to get IP address of the container , type below command <\/p>\n\n\n\n
$ docker inspect <CONTAINER_ID_OF_my-pg-db> | grep IPAddress<\/code><\/pre>\n\n\n\n
the IP address returned by this command should be used at Host Name\/address field .
Other fileds are similar to environment variables provided to my-pg-db in you docker-compose.yaml file. Click on save and you will see the database listed in you server.<\/p>\n\n\n\n
To access this database from  your development environment just use IP as localhost and port as mention in docker file (int this case 53432)<\/p>\n\n\n\n
for example your JDBC url should look like for postgres database<\/p>\n\n\n\n
jdbc:postgresql:\/\/localhost:5432\/postgres<\/code><\/pre>\n\n\n\n
That’s it , it is as simple as that . <\/p>\n","protected":false},"excerpt":{"rendered":"
Docker makes all development things really easy. Just one line command and you are up with whatever you want (of course if it’s available as docker Image \ud83d\ude09). Gone are those days when you have to spend hour or so to setup just a simple database on you local development environment , worrying about process … <\/p>\n
Continue reading “Postgres Database and PG Admin using Docker Compose”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/posts\/160"}],"collection":[{"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/comments?post=160"}],"version-history":[{"count":1,"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/posts\/160\/revisions"}],"predecessor-version":[{"id":165,"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/posts\/160\/revisions\/165"}],"wp:attachment":[{"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/media?parent=160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/categories?post=160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tejasgarde.dev\/index.php\/wp-json\/wp\/v2\/tags?post=160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}