backup.bash

psql -U postgres -h localhost \
-XAtc "SELECT tablename FROM pg_catalog.pg_tables where schemaname='public'" | while read table
do psql -U postgres -h localhost \
-c "\copy (SELECT * FROM $table) to $table.csv with csv header"
done

start_db.bash

docker run -it --rm --name="postgres" \
  --publish="5432:5432" \
  --volume 'postgres-14-data:/var/lib/postgresql/data' \
  --env='POSTGRES_HOST_AUTH_METHOD=trust' \
  postgres:14