Saturday, February 15, 2020

Don’t install Postgres, just PuLL iT



https://hackernoon.com/dont-install-postgres-docker-pull-postgres-bee20e200198
https://hackernoon.com/docker-commands-the-ultimate-cheat-sheet-994ac78e2888
https://www.enterprisedb.com/postgres-tutorials/how-install-postgres-docker
https://github.com/docker-library/postgres
https://www.jrebel.com/blog/docker-commands-cheat-sheethttps://www.jrebel.com/system/files/docker-commands-cheat-sheet.pdf




apt install docker.io

systemctl status docker
docker pull postgres:9.6.17-alpine

docker images
docker ps
docker run
docker exec
docker start
docker stop


root@breaker:/home/learn/docker# docker run --rm   --name pg-docker -e POSTGRES_PASSWORD=docker -d -p 5432:5432 -v $HOME/docker/volumes/postgres:/var/lib/postgresql/data  postgres

Unable to find image 'postgres:latest' locally
latest: Pulling from library/postgres
bc51dd8edc1b: Pull complete 
d2b355dbb6c6: Pull complete 
d237363a1a91: Pull complete 
ff4b9d2fde66: Pull complete 
646492d166e7: Pull complete 
50eeac6fd5fb: Pull complete 
502963de6da8: Pull complete 
d7263f7627b9: Pull complete 
d234d8f1a205: Pull complete 
1b2c24e5275c: Pull complete 
3f7c6dd9a7ae: Pull complete 
d6d6977a74b3: Pull complete 
acf1093f8b78: Pull complete 
77e1ac8c247a: Pull complete 
Digest: sha256:f8ffd650ecc802c8e45d9e72b7ba90829c3d89df3075a23b3f8e966728cfd97c
Status: Downloaded newer image for postgres:latest
aff1e95e8a9ad2ff6b0183785d3515114d28dbc83f17768123293d654cb69be1
root@breaker:/home/learn/docker# 


root@breaker:/home/learn/docker# docker ps

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                    NAMES
aff1e95e8a9a        postgres            "docker-entrypoint.s…"   15 minutes ago      Up 15 minutes       0.0.0.0:5432->5432/tcp   pg-docker

root@breaker:/home/learn/docker# 



root@breaker:/home/learn/docker# docker exec -it pg-docker bash

root@aff1e95e8a9a:/# 
root@aff1e95e8a9a:/# cat /etc/*rele*
PRETTY_NAME="Debian GNU/Linux 10 (buster)"
NAME="Debian GNU/Linux"
VERSION_ID="10"
VERSION="10 (buster)"
VERSION_CODENAME=buster
ID=debian
HOME_URL="https://www.debian.org/"
SUPPORT_URL="https://www.debian.org/support"
BUG_REPORT_URL="https://bugs.debian.org/"
root@aff1e95e8a9a:/# 
root@aff1e95e8a9a:/# 
root@aff1e95e8a9a:/# exit
exit
root@breaker:/home/learn/docker# 
root@breaker:/home/learn/docker# cat /etc/*rele*
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=16.04
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION="Ubuntu 16.04.5 LTS"
NAME="Ubuntu"
VERSION="16.04.5 LTS (Xenial Xerus)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 16.04.5 LTS"
VERSION_ID="16.04"
HOME_URL="http://www.ubuntu.com/"
SUPPORT_URL="http://help.ubuntu.com/"
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"
VERSION_CODENAME=xenial
UBUNTU_CODENAME=xenial
root@breaker:/home/learn/docker# 


root@breaker:/home/learn/docker# psql -h localhost -U postgres -d postgres

Password for user postgres: 
psql (11.1 (Ubuntu 11.1-1.pgdg16.04+1), server 12.2 (Debian 12.2-1.pgdg100+1))
WARNING: psql major version 11, server major version 12.
         Some psql features might not work.
Type "help" for help.

postgres=# 




root@breaker:/home/learn/docker# docker run  --name pg-docker -e POSTGRES_PASSWORD=docker -d -p 5496:5432 -v $HOME/docker/postgres:/var/lib/postgresql/data  postgres:9.6.17-alpine

ea6aa193cdd19bf151601ee27464a08d6934de1704f84bfc3428fe0f7cf566ba
root@breaker:/home/learn/docker# 
root@breaker:/home/learn/docker# psql -h localhost -U postgres -p 5496 -d postgres
Password for user postgres: 
psql (11.1 (Ubuntu 11.1-1.pgdg16.04+1), server 9.6.17)
Type "help" for help.


postgres=# 

postgres=# select version();
                                         version                                         
-----------------------------------------------------------------------------------------
 PostgreSQL 9.6.17 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.2.0) 9.2.0, 64-bit
(1 row)

postgres=# 


root@breaker:/home/learn/docker# docker ps

CONTAINER ID        IMAGE                    COMMAND                  CREATED             STATUS              PORTS                    NAMES
ea6aa193cdd1        postgres:9.6.17-alpine   "docker-entrypoint.s…"   4 minutes ago       Up 4 minutes        0.0.0.0:5496->5432/tcp   pg-docker
root@breaker:/home/learn/docker# 


root@breaker:/home/learn/docker# docker ps
CONTAINER ID        IMAGE                    COMMAND                  CREATED             STATUS              PORTS                    NAMES
ea6aa193cdd1        postgres:9.6.17-alpine   "docker-entrypoint.s…"   11 minutes ago      Up 17 seconds       0.0.0.0:5496->5432/tcp   pg-docker
root@breaker:/home/learn/docker# 
root@breaker:/home/learn/docker# docker stop pg-docker
pg-docker
root@breaker:/home/learn/docker# 
root@breaker:/home/learn/docker# docker ps
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS               NAMES
root@breaker:/home/learn/docker# 
root@breaker:/home/learn/docker# docker start pg-docker
pg-docker
root@breaker:/home/learn/docker# 
root@breaker:/home/learn/docker# docker ps
CONTAINER ID        IMAGE                    COMMAND                  CREATED             STATUS              PORTS                    NAMES
ea6aa193cdd1        postgres:9.6.17-alpine   "docker-entrypoint.s…"   11 minutes ago      Up 2 seconds        0.0.0.0:5496->5432/tcp   pg-docker

root@breaker:/home/learn/docker# 


root@breaker:/home/learn/docker# docker images
REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
postgres            9.6.17-alpine       b1adbeb9895f        19 hours ago        38.2MB
postgres            latest              0d2531ee3abd        20 hours ago        397MB

root@breaker:/home/learn/docker# 

No comments:

Post a Comment