Category: docker

Kubernetes-Based Deployment of the Kimai Time Tracking Platform

adminLeave a comment

Kimai is an open-source time tracking platform designed for project-based work. It is built with Symfony and relies on a MySQL database for persistent storage, making it a solid candidate for deployment in a Kubernetes environment.

In a previous deployment of WordPress, I did not define resource requests and limits for my pods, which led to node resource exhaustion and instability. This time, I will explicitly configure resource constraints to avoid similar issues.

Before moving to Kubernetes manifests, I performed an initial installation on a Debian Trixie server to better understand the application’s structure and runtime requirements.

Continue reading “Kubernetes-Based Deployment of the Kimai Time Tracking Platform” →

Run Postgresql inside Docker container for local development

adminLeave a comment

Run Postgresql inside container with persistent data in docker volume. Useful for local development. 

docker run --name my_postgres -e POSTGRES_PASSWORD=mysecretpassword -p 5433:5432 -d -v pgdata:/var/lib/postgresql/data postgres:14.5
  • –name Name you container
  • -e POSTGRES_PASSWORD=mysecretpassword Option for postgres user password
  • -p 5433:5432 Option to expose port, 5433 will be exposed to the local machine
  • -d Option for detached mode, running in background
  • -v pgdata:/var/lib/postgresql/data Option to create pgdata volume and connect it inside container folder /var/lib/postgresql/data
  • postgres:14.5 Postgres image and version. Find more here.

If you do not believe me that the data will be saved even when container is deleted, try this:

##Connect to database
psql -h localhost -p 5433 -U postgres -d postgres

##Create a database
CREATE DATABASE dvdrental;

### import testing database. Download and extract this one for example: http://blog.twis7.com/dvdrental.zip
pg_restore -h localhost -p 5433 -U postgres -d dvdrental /path/to/downloaded/dabase/dvdrental.tar

## connect to database
\c dvdrental

## display all tables
\dt

## stop and remove the container
docker stop my_postgres
docker rm my_postgres

## start the container again
docker run --name my_postgres -e POSTGRES_PASSWORD=mysecretpassword -p 5433:5432 -d -v pgdata:/var/lib/postgresql/data postgres:14.5

##Check the database again. Everything will be inside as expected.