Installing Docker Engine<\/h2>\n\n\n\n
Follow the steps provided in our article below to setup Docker environment on your Linux system. Windows and macOS users can user GUI based tools such as Docker Desktop and Portainer.<\/p>\n\n\n\n
- \n
- How To Install Docker Engine on Linux Systems<\/a><\/li>\n<\/ul>\n\n\n\n
After the installation confirm by checking the version release.<\/p>\n\n\n\n
$ docker --version<\/mark>\nDocker version 25.0.3, build 4debf41<\/code><\/pre>\n\n\n\nCreate Compose file for PostgreSQL<\/h2>\n\n\n\n
Create data directory for PostgreSQL database<\/p>\n\n\n\n
mkdir ~\/postgresql && cd ~\/postgresql<\/code><\/pre>\n\n\n\nCreate Compose file that will define how the contaier should be created.<\/p>\n\n\n\n
vim docker-compose.yml<\/code><\/pre>\n\n\n\nNext we define the contents of the YAM file. The container images on Docker Hub<\/a> is what we’re using to create a running instance of PostgreSQL server. Database data will be stored in the local directory .\/pgdata<\/em><\/strong>.<\/p>\n\n\n\n
We also create a container that is running Admirer PostgreSQL<\/a> web based management tool.<\/p>\n\n\n\n
- \n
- PostgreSQL 16<\/strong><\/li>\n<\/ul>\n\n\n\n
services:\n db:\n image: postgres:16-bookworm\n restart: always\n environment:\n POSTGRES_PASSWORD: StrongPassword01<\/mark>\n volumes:\n - .\/pgdata:\/var\/lib\/postgresql\/data\n\n adminer:\n image: adminer\n restart: always\n ports:\n - 8080:8080<\/code><\/pre>\n\n\n\n- \n
- PostgreSQL 15<\/strong><\/li>\n<\/ul>\n\n\n\n
services:\n db:\n image: postgres:15-bookworm\n restart: always\n environment:\n POSTGRES_PASSWORD: StrongPassword01<\/mark>\n volumes:\n - .\/pgdata:\/var\/lib\/postgresql\/data\n\n adminer:\n image: adminer\n restart: always\n ports:\n - 8080:8080<\/code><\/pre>\n\n\n\n- \n
- PostgreSQL 14<\/strong><\/li>\n<\/ul>\n\n\n\n
services:\n db:\n image: postgres:14-bookworm\n restart: always\n environment:\n POSTGRES_PASSWORD: StrongPassword01<\/mark>\n volumes:\n - .\/pgdata:\/var\/lib\/postgresql\/data\n\n adminer:\n image: adminer\n restart: always\n ports:\n - 8080:8080<\/code><\/pre>\n\n\n\n- \n
- PostgreSQL 13<\/strong><\/li>\n<\/ul>\n\n\n\n
services:\n db:\n image: postgres:13-bookworm\n restart: always\n environment:\n POSTGRES_PASSWORD: StrongPassword01<\/mark>\n volumes:\n - .\/pgdata:\/var\/lib\/postgresql\/data\n\n adminer:\n image: adminer\n restart: always\n ports:\n - 8080:8080<\/code><\/pre>\n\n\n\n- \n
- PostgreSQL 12<\/strong><\/li>\n<\/ul>\n\n\n\n
services:\n db:\n image: postgres:12-bookworm\n restart: always\n environment:\n POSTGRES_PASSWORD: StrongPassword01<\/mark>\n volumes:\n - .\/pgdata:\/var\/lib\/postgresql\/data\n\n adminer:\n image: adminer\n restart: always\n ports:\n - 8080:8080<\/code><\/pre>\n\n\n\n- \n
- PostgreSQL 11<\/strong><\/li>\n<\/ul>\n\n\n\n
services:\n db:\n image: postgres:11-bookworm\n restart: always\n environment:\n POSTGRES_PASSWORD: StrongPassword01<\/mark>\n volumes:\n - .\/pgdata:\/var\/lib\/postgresql\/data\n\n adminer:\n image: adminer\n restart: always\n ports:\n - 8080:8080<\/code><\/pre>\n\n\n\nRunning PostgreSQL server in container<\/h2>\n\n\n\n
Next we start the container by running the compose up commands. The
-d<\/code> option keep it running in detached mode (background) without active interactive session.<\/p>\n\n\n\n$ docker compose up -d<\/mark>\n[+] Running 22\/22\n \u2714<\/mark> adminer 7 layers<\/mark> [\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff<\/mark>] 0B\/0B Pulled 11.0s<\/mark>\n \u2714<\/mark> 09e2bc8a597c Pull complete 0.9s<\/mark>\n \u2714<\/mark> 092a59d5d649 Pull complete 0.7s<\/mark>\n \u2714<\/mark> e4dca1b56763 Pull complete 0.4s<\/mark>\n \u2714<\/mark> 378feffe5197 Pull complete 0.8s<\/mark>\n \u2714<\/mark> 3bd4de3ac847 Pull complete 1.1s<\/mark>\n \u2714<\/mark> 44d5566ceca7 Pull complete 1.1s<\/mark>\n \u2714<\/mark> 3dafa7b9d4fc Pull complete 1.3s<\/mark>\n \u2714<\/mark> db 13 layers<\/mark> [\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff\u28ff<\/mark>] 0B\/0B Pulled 13.5s<\/mark>\n \u2714<\/mark> 1f7ce2fa46ab Pull complete 1.8s<\/mark>\n \u2714<\/mark> e75b44f17b07 Pull complete 1.6s<\/mark>\n \u2714<\/mark> d601ea737a84 Pull complete 2.9s<\/mark>\n \u2714<\/mark> 0f4fcee3f93d Pull complete 2.1s<\/mark>\n \u2714<\/mark> 428f7aff61bc Pull complete 2.6s<\/mark>\n \u2714<\/mark> 7787ed5ab4f3 Pull complete 3.0s<\/mark>\n \u2714<\/mark> 3d2b66cffddc Pull complete 3.3s<\/mark>\n \u2714<\/mark> e7dee0dd847b Pull complete 3.3s<\/mark>\n \u2714<\/mark> a24060178bac Pull complete 5.8s<\/mark>\n \u2714<\/mark> 0eb290c85bd2 Pull complete 4.2s<\/mark>\n \u2714<\/mark> 88b80c4fe471 Pull complete 3.9s<\/mark>\n \u2714<\/mark> eac33d14a11e Pull complete 4.4s<\/mark>\n \u2714<\/mark> d40b681a9814 Pull complete 4.9s<\/mark>\n[+] Running 2\/3\n \u280b Network postgresql_default Created 1.0s<\/mark>\n \u2714<\/mark> Container postgresql-adminer-1 Started<\/mark> 0.8s<\/mark>\n \u2714<\/mark> Container postgresql-db-1 Started<\/mark> 0.7s<\/mark><\/code><\/pre>\n\n\n\nConfirm status of the container by executing the docker compose<\/a> with
ps<\/code> flag.<\/p>\n\n\n\n$ docker compose ps<\/mark>\nNAME IMAGE COMMAND SERVICE CREATED STATUS PORTS\npostgresql-adminer-1 adminer \"entrypoint.sh php -\u2026\" adminer 5 minutes ago Up 5 minutes 0.0.0.0:8080->8080\/tcp, :::8080->8080\/tcp\npostgresql-db-1 postgres:11-bookworm \"docker-entrypoint.s\u2026\" db 5 minutes ago Up 5 minutes 5432\/tcp<\/code><\/pre>\n\n\n\nTo enter container shell, run;<\/p>\n\n\n\n
$ docker exec -ti postgresql-db-1 bash<\/mark>\nroot@a79ad82fd433:\/#<\/code><\/pre>\n\n\n\nThe version of PostgreSQL server can be checked using
psql -V<\/code> command.<\/p>\n\n\n\nroot@a79ad82fd433:\/# psql -V<\/mark>\npsql (PostgreSQL) 11.22 (Debian 11.22-1.pgdg120+1)<\/code><\/pre>\n\n\n\nFrom there you can start
psql<\/code> which is a terminal-based front-end to PostgreSQL.<\/p>\n\n\n\nroot@a79ad82fd433:\/# su - postgres<\/mark>\npostgres@a79ad82fd433:~$ psql<\/mark>\npsql (11.22 (Debian 11.22-1.pgdg120+1))\nType \"help\" for help.\n\npostgres=#<\/code><\/pre>\n\n\n\nWe can create a test user and database;<\/p>\n\n\n\n
- \n
- Database user: computingforgeeks<\/strong><\/li>\n\n\n\n
- Database name: mywebsite<\/strong><\/li>\n\n\n\n
- Password: Str0ngPassw0rd<\/strong><\/li>\n<\/ul>\n\n\n\n
postgres=# CREATE USER<\/mark> computingforgeeks<\/mark> WITH PASSWORD<\/mark> 'Str0ngPassw0rd<\/mark>';\nCREATE ROLE\n\npostgres=# CREATE DATABASE <\/mark>mywebsite<\/mark> WITH OWNER = 'computingforgeeks<\/mark>';<\/mark>\nCREATE DATABASE<\/code><\/pre>\n\n\n\nTo exit the PostgreSQL and container shell use the
exit<\/code> command three times.<\/p>\n\n\n\npostgres=# exit<\/mark>\npostgres@a79ad82fd433:~$ exit<\/mark>\nlogout\nroot@a79ad82fd433:\/# exit<\/mark>\nexit\n[root@rocky8 postgresql]#<\/code><\/pre>\n\n\n\nDatabase data will be stored in .\/pgdata<\/em><\/strong> as defined in the compose file.<\/p>\n\n\n\n
$ ls -1 pgdata\/<\/mark>\nbase\nglobal\npg_commit_ts\npg_dynshmem\npg_hba.conf\npg_ident.conf\npg_logical\npg_multixact\npg_notify\npg_replslot\npg_serial\npg_snapshots\npg_stat\npg_stat_tmp\npg_subtrans\npg_tblspc\npg_twophase\nPG_VERSION\npg_wal\npg_xact\npostgresql.auto.conf\npostgresql.conf\npostmaster.opts\npostmaster.pid<\/code><\/pre>\n\n\n\nAccessing Admirer dashboard<\/h2>\n\n\n\n
Open your web browser on http:\/\/ServerIP:8080.<\/strong><\/p>\n\n\n\n
![\"\"](\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2024\/02\/Run-PosgreSQL-Docker-Container-1024x441.png\" "\\"\\"")
<\/figure>\n\n\n\nLogin as user, database and with the password.<\/p>\n\n\n\n
![\"\"](\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2024\/02\/Run-PosgreSQL-Docker-Container-02-1024x466.png\" "\\"\\"")
<\/figure>\n\n\n\nYou will get a dashboard similar to one shown below. From here you can manage your database – create tables, functions, views, import data e.t.c.<\/p>\n\n\n\n
![\"\"](\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2024\/02\/Run-PosgreSQL-Docker-Container-03-1024x462.png\" "\\"\\"")
<\/figure>\n\n\n\nConclusion<\/h2>\n\n\n\n
By running PostgreSQL database in a container you enjoy the efficiency of administering it. The other benefits of containerization range from portability, isolation to scalability. You can lift the container image with data and run in a separate host within seconds. Deciding whether to adopt containerized database boils down to your use preference.<\/p>\n","protected":false},"excerpt":{"rendered":"
PostgreSQL is an open source and enterprise-class relational database system with the support for SQL and JSON querying. PostgreSQL has the backing of more than 20 years of community development. This guarantees the highest levels of integrity, performance, and resilience. The most common application of PostgreSQL is in data warehouse for mobile, web and analytics … Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":145173,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[316,461,27,299,37631],"tags":[39006],"class_list":["post-152521","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-containers","category-databases","category-docker","category-how-to","category-postgresql","tag-postgresql-server-in-docker-container"],"_links":{"self":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts\/152521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/comments?post=152521"}],"version-history":[{"count":0,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts\/152521\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/media\/145173"}],"wp:attachment":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/media?parent=152521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/categories?post=152521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/tags?post=152521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Database name: mywebsite<\/strong><\/li>\n\n\n\n
- Database user: computingforgeeks<\/strong><\/li>\n\n\n\n
- PostgreSQL 11<\/strong><\/li>\n<\/ul>\n\n\n\n
- PostgreSQL 12<\/strong><\/li>\n<\/ul>\n\n\n\n
- PostgreSQL 13<\/strong><\/li>\n<\/ul>\n\n\n\n
- PostgreSQL 14<\/strong><\/li>\n<\/ul>\n\n\n\n
- PostgreSQL 15<\/strong><\/li>\n<\/ul>\n\n\n\n
- PostgreSQL 16<\/strong><\/li>\n<\/ul>\n\n\n\n