docker volume create db_data
docker run --rm -d --name psql_db -v db_data:/var/lib/postgresql/data -e POSTGRES_PASSWORD=1234 postgres:16.1-bullseye
$ docker exec -it psql_db /bin/bash
root@7523c983f729:/
psql (16.1 (Debian 16.1-1.pgdg110+1))
Type "help" for help.
CREATE TABLE IF NOT EXISTS cloud_wave (
id SERIAL PRIMARY KEY,
timestamp timestamp
);
postgres=
List of relations
Schema | Name | Type | Owner
--------+------------+-------+----------
public | cloud_wave | table | postgres
(1 row)
docker stop psql_db
psql_db
$ docker run --rm -d --name psql_db -v db_data:/var/lib/postgresql/data -e
POSTGRES_PASSWORD=mysecretpassword postgres:16.1-bullseye