Docker - Run PostgreSQL

zzh@ZZHPC:~$ docker pull postgres:alpine

zzh@ZZHPC:~$ docker images
REPOSITORY   TAG       IMAGE ID       CREATED       SIZE
postgres     alpine    642d75c6be0c   9 days ago    245MB

 

zzh@ZZHPC:~$ docker run --name postgres16 -p 5432:5432 -e POSTGRES_USER=root -e POSTGRES_PASSWORD=aaa -d postgres:alpine

 

zzh@ZZHPC:~$ docker exec -it postgres16 psql -U root
psql (16.1)
Type "help" for help.

root=# select now();
              now              
-------------------------------
 2023-11-19 08:53:49.839546+00
(1 row)

root=# \q
zzh@ZZHPC:~$

 

zzh@ZZHPC:~$ docker exec -it postgres16 /bin/sh
/ # createdb --username=root --owner=root simple_bank
/ # psql simple_bank
psql (16.1)
Type "help" for help.

simple_bank=# \q
/ # dropdb simple_bank
/ # exit

 

zzh@ZZHPC:~$ docker exec -it postgres16 createdb --username=root --owner=root simple_bank
zzh@ZZHPC:~$ docker exec -it postgres16 psql -U root simple_bank
psql (16.1)
Type "help" for help.

simple_bank=#