{"id":235,"date":"2021-02-10T23:20:43","date_gmt":"2021-02-10T14:20:43","guid":{"rendered":"https:\/\/osmanthus.work\/?p=235"},"modified":"2021-03-31T22:15:24","modified_gmt":"2021-03-31T13:15:24","slug":"using-postgresql-using-docker","status":"publish","type":"post","link":"https:\/\/osmanthus.work\/?p=235","title":{"rendered":"Using PostgreSQL on Docker"},"content":{"rendered":"\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">1. Prerequities<\/h2>\n\n\n\n<p>OS: CentOS7<br>PostgreSQL: PostgreSQL13<br>Docker version 20.10<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. Setup Docker<\/h2>\n\n\n\n<p>(1) Install docker engine performing the following commands<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo yum install -y yum-utils\nsudo yum-config-manager --add-repo https:\/\/download.docker.com\/linux\/centos\/docker-ce.repo\nsudo yum makecache fast\nsudo yum install docker-ce\nsystemctl enable docker<\/code><\/pre>\n\n\n\n<p>(2) Check whether docker engine runs sample container or not<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker run hello-world\ndocker stop hello-world<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">3. Using PostgreSQL from Docker<\/h2>\n\n\n\n<p>(1) Run PostgreSQL from docker engine<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker run -d --name postgres -e POSTGRES_PASSWORD=postgres -p 15432:5432 -v docker run -d --name postgres13-server1 -e POSTGRES_PASSWORD=postgres -p 15432:5432 -v \/tmp\/pgsql13\/data:\/var\/lib\/postgresql\/data postgres:13-alpine<\/code><\/pre>\n\n\n\n<p>(2) Check whether PostgreSQL is running or not<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker ps<\/code><\/pre>\n\n\n\n<p>(3) If PostgreSQL is running then the container information such as the following is shown<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CONTAINER ID   IMAGE                COMMAND                  CREATED         STATUS         PORTS                     NAMES\nc78000879d49   postgres:13-alpine   \"docker-entrypoint.s\u2026\"   9 seconds ago   Up 8 seconds   0.0.0.0:15432-&gt;5432\/tcp   postgres13-server1<\/code><\/pre>\n\n\n\n<p>(3) Connect to PostgreSQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>psql -U postgres -h 0.0.0.0 -p 15432<\/code><\/pre>\n\n\n\n<p>(4) Stop PostgreSQL container. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker stop postgres13-server1<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">4. References<\/h2>\n\n\n\n<p>[1] Install Docker Engine on CentOS<br><a href=\"https:\/\/docs.docker.com\/engine\/install\/centos\/\">https:\/\/docs.docker.com\/engine\/install\/centos\/<\/a><\/p>\n\n\n\n<p>[2] PostgreSQL Docker Official Images<br><a href=\"https:\/\/hub.docker.com\/_\/postgres?tab=tags&amp;page=1&amp;ordering=last_updated\">https:\/\/hub.docker.com\/_\/postgres?tab=tags&amp;page=1&amp;ordering=last_updated<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-235","post","type-post","status-publish","format-standard","hentry","category-postgresql","entry"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/osmanthus.work\/index.php?rest_route=\/wp\/v2\/posts\/235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/osmanthus.work\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/osmanthus.work\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/osmanthus.work\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/osmanthus.work\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=235"}],"version-history":[{"count":8,"href":"https:\/\/osmanthus.work\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions"}],"predecessor-version":[{"id":274,"href":"https:\/\/osmanthus.work\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions\/274"}],"wp:attachment":[{"href":"https:\/\/osmanthus.work\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/osmanthus.work\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/osmanthus.work\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}