Create and Configure Docker Postgres

[personam-solis]

Create a PostgreSQL DB server using Docker (postgres:16). The below need to be considered for authentication and usability

• OS/DB Users
• Parallel Processing
• Threads
• Memory
• Permanent Volume Location

Bonus: user pgadmin Docker container

[personam-solis]

Create a repo for any container that is made

[personam-solis]

Container Memory - Max of 8 GB DB Memory - 90% Threads - 4

[personam-solis]

docker run --rm -d \
    -p 5455:5432  \
    --cpus 4 \
    --health-timeout 30s \
    --memory 9g \
    --mount source=cladis,target=/var/lib/postgresql

[personam-solis]

postgres configs:

• shared_buffers = 8GB
• max_parallel_workers_per_gather = 3
• max_parallel_maintenance_workers = 1
• max_parallel_workers = 4

[personam-solis]

USE THE DOCKER API

check if the cladis volume exists, if not, ask the user where they want it to be

Docker Volume:

docker volume create --driver local \
    --opt type=nfs \
    --opt o=addr=192.168.1.1,rw \
    --opt device=:/path/to/dir \
    foo

[personam-solis]

users:

• cladis_rw
• cladis_ro

[personam-solis]

ready to start working on the test

[personam-solis]

Logging cookbook https://docs.python.org/3/howto/logging-cookbook.html

[personam-solis]

When an exception happens, delete the container!!

[personam-solis]

raise an exception but customize it when it happens AFTER deleting the container