Docker workshop home task

output.txt

svisor@mbp:~/workspace/thinknetica/workshops$ docker image list |grep postgres
postgres                 9.6                 bb00980cabc0        8 weeks ago         200MB
svisor@mbp:~/workspace/thinknetica/workshops$ docker pull postgres:13.1-alpine
13.1-alpine: Pulling from library/postgres
188c0c94c7c5: Already exists 
56f1d1b70e7f: Pull complete 
9b4f01476d2b: Pull complete 
354372ef1765: Pull complete 
9b2c2c47ed52: Pull complete 
4a51019c1737: Pull complete 
a73459c934ba: Pull complete 
49a02dcc4168: Pull complete 
Digest: sha256:42c1b84839db8f78bb66b3d6f300a88a8517895454df4a1cb2f101dfae609769
Status: Downloaded newer image for postgres:13.1-alpine
docker.io/library/postgres:13.1-alpine
svisor@mbp:~/workspace/thinknetica/workshops$ ls
docker		test.sql
svisor@mbp:~/workspace/thinknetica/workshops$ pwd
/Users/svisor/workspace/thinknetica/workshops
svisor@mbp:~/workspace/thinknetica/workshops$ mkdir postgres-data
svisor@mbp:~/workspace/thinknetica/workshops$ ls postgres-data/
svisor@mbp:~/workspace/thinknetica/workshops$ docker ps -a |grep postgres:13
svisor@mbp:~/workspace/thinknetica/workshops$ docker run --name postgres -e POSTGRES_PASSWORD=super_password -d -p 54320:5432 -v ~/workspace/thinknetica/workshops/postgres-data/:/var/lib/postgresql/data:rw postgres:13.1-alpine
389c44a289ab560b3486f21c9ae4c3f6a220a4d54ef10e2216403a5b6472f72f
svisor@mbp:~/workspace/thinknetica/workshops$ ls postgres-data/
PG_VERSION		pg_dynshmem		pg_multixact		pg_snapshots		pg_tblspc		postgresql.auto.conf
base			pg_hba.conf		pg_notify		pg_stat			pg_twophase		postgresql.conf
global			pg_ident.conf		pg_replslot		pg_stat_tmp		pg_wal
pg_commit_ts		pg_logical		pg_serial		pg_subtrans		pg_xact
svisor@mbp:~/workspace/thinknetica/workshops$ docker ps
CONTAINER ID        IMAGE                  COMMAND                  CREATED              STATUS              PORTS                     NAMES
389c44a289ab        postgres:13.1-alpine   "docker-entrypoint.s…"   About a minute ago   Up About a minute   0.0.0.0:54320->5432/tcp   postgres
svisor@mbp:~/workspace/thinknetica/workshops$ psql -U postgres -W -h localhost -p 54320
Password: 
psql (13.0, server 13.1)
Type "help" for help.

postgres=# create database docker_workshop;
CREATE DATABASE
postgres=# \c docker_workshop
Password for user postgres: 
psql (13.0, server 13.1)
You are now connected to database "docker_workshop" as user "postgres".
docker_workshop=# \i test.sql
SET
SET
SET
SET
SET
 set_config 
------------
 
(1 row)

SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE

-----skip long output-------

CREATE INDEX
docker_workshop=# \q
svisor@mbp:~/workspace/thinknetica/workshops$ docker stop postgres
postgres
svisor@mbp:~/workspace/thinknetica/workshops$ docker ps -a |grep postgres:13
389c44a289ab        postgres:13.1-alpine            "docker-entrypoint.s…"   5 minutes ago       Exited (0) 51 seconds ago                       postgres
svisor@mbp:~/workspace/thinknetica/workshops$ docker rm 389c44a289ab
389c44a289ab
svisor@mbp:~/workspace/thinknetica/workshops$ ls postgres-data/
PG_VERSION		pg_dynshmem		pg_multixact		pg_snapshots		pg_tblspc		postgresql.auto.conf
base			pg_hba.conf		pg_notify		pg_stat			pg_twophase		postgresql.conf
global			pg_ident.conf		pg_replslot		pg_stat_tmp		pg_wal			postmaster.opts
pg_commit_ts		pg_logical		pg_serial		pg_subtrans		pg_xact
svisor@mbp:~/workspace/thinknetica/workshops$ docker run --name postgres -e POSTGRES_PASSWORD=super_password -d -p 54320:5432 -v ~/workspace/thinknetica/workshops/postgres-data/:/var/lib/postgresql/data:rw postgres:13.1-alpine
7c60780e64ae2dd3625269b29582141ef677b480c3c4edc79745b7f508b18c8b
svisor@mbp:~/workspace/thinknetica/workshops$ psql -U postgres -W -h localhost -p 54320 -d docker_workshop
Password: 
psql (13.0, server 13.1)
Type "help" for help.

docker_workshop=# \dt+ public.*
                                       List of relations
 Schema |           Name           | Type  |  Owner   | Persistence |    Size    | Description 
--------+--------------------------+-------+----------+-------------+------------+-------------
 public | categories               | table | postgres | permanent   | 16 kB      | 
 public | category_translations    | table | postgres | permanent   | 16 kB      | 
 public | designation_translations | table | postgres | permanent   | 16 kB      | 
 public | designations             | table | postgres | permanent   | 16 kB      | 
 public | intro_images             | table | postgres | permanent   | 16 kB      | 
 public | member_translations      | table | postgres | permanent   | 16 kB      | 
 public | members                  | table | postgres | permanent   | 16 kB      | 

-----skip long table list-------

 public | schema_migrations        | table | postgres | permanent   | 16 kB      | 
 public | screenshots              | table | postgres | permanent   | 48 kB      | 
 public | users                    | table | postgres | permanent   | 16 kB      | 
(17 rows)

docker_workshop=#