PostgreSQL Patterns — SOL Server

Overview

PostgreSQL 16 Alpine serves as the shared relational database for multiple applications on the SOL server. Two databases (gitea and keycloak) run on a single instance with dedicated users. The instance is exposed only on localhost (127.0.0.1:5432) to prevent external access. Administration happens via pgAdmin (protected by OAuth2 Proxy + Keycloak) or via docker exec commands. All containers connect through the shared Docker network using the hostname postgres.

When to Use

Creating a new database for a service joining the SOL stack
Debugging database connection issues between containers and PostgreSQL
Running emergency admin queries (promote users, fix redirect URIs, inspect state)
Setting up init scripts for automatic database provisioning on first start
Configuring pgAdmin access for web-based administration
Performing manual or automated backup and restore operations

PostgreSQL Patterns — SOL Server

Overview

When to Use

Creating a new database for a service joining the SOL stack
Debugging database connection issues between containers and PostgreSQL
Running emergency admin queries (promote users, fix redirect URIs, inspect state)
Setting up init scripts for automatic database provisioning on first start
Configuring pgAdmin access for web-based administration
Performing manual or automated backup and restore operations

Postgresql Patterns

PostgreSQL Patterns — SOL Server

Overview

When to Use

Postgresql Patterns

PostgreSQL Patterns — SOL Server

Overview

When to Use

Docker Compose Configuration

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns