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=#