testing-postgresql-persistent-data.md

Final work is here and a working SDL manifest

What's below on this page is outdated:

---

1. Init the DB with postgres:adminpass creds

docker network create pgnet1
docker volume create pgvol1
docker run -d --name db1 --hostname db1 --network pgnet1 -e POSTGRES_PASSWORD=adminpass -v pgvol1:/var/lib/postgresql/data postgres:14

2. Create a new DB "newdb", with newdb_user:userpass creds

docker run --rm -ti --network pgnet1 -e PGPASSWORD=adminpass -e PGUSER=postgres -e PGHOST=db1 -u postgres --entrypoint psql postgres:14

CREATE USER newdb_user;
CREATE DATABASE newdb;
GRANT ALL PRIVILEGES ON DATABASE newdb TO newdb_user;
ALTER USER newdb_user WITH PASSWORD 'userpass';

\l+
\q

3. Connect to the "newdb" with "newdb_user" and create a table called "company"

docker run --rm -ti --network pgnet1 -e PGPASSWORD=userpass -e PGUSER=newdb_user -e PGDATABASE=newdb -e PGHOST=db1 -u postgres --entrypoint psql postgres:14

CREATE TABLE COMPANY(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL
);

\dt+
\q

4. Restart the db1

docker logs db1
docker restart db1
docker logs db1

5. Check the connection and the table again

docker run --rm -ti --network pgnet1 -e PGPASSWORD=userpass -e PGUSER=newdb_user -e PGDATABASE=newdb -e PGHOST=db1 -u postgres --entrypoint psql postgres:14

\dt+
\q

6. Tear everything down

docker rm -f db1
docker volume rm pgvol1
docker network rm pgnet1

Final work is here and a working SDL manifest