mirror of https://github.com/kevinveenbirkenbach/computer-playbook.git synced 2025-10-09 18:28:10 +02:00

Files

Kevin Veen-Birkenbach 8beda2d45d fix(svc-db-postgres): pin Postgres version to 17-3.5, add entity_name var, and dynamically resolve major version for dev package

- Changed default Docker image version from 'latest' to '17-3.5' in config
- Introduced entity_name var for consistent lookups
- Added POSTGRES_VERSION and POSTGRES_VERSION_MAJOR extraction
- Updated Dockerfile to install postgresql-server-dev-<major> with default fallback to 'all'
- Minor YAML formatting improvements

Ref: https://chatgpt.com/share/68de40b4-2eb8-800f-ab5b-11cc873c3604

2025-10-02 11:07:17 +02:00

config

fix(svc-db-postgres): pin Postgres version to 17-3.5, add entity_name var, and dynamically resolve major version for dev package

2025-10-02 11:07:17 +02:00

defaults

Solved ooauth2 bugs and restructured postgres roile to implement extensions used by discourse

2025-07-23 13:24:55 +02:00

filter_plugins

Implement filter checks: ensure all defined filters are used and remove dead code

2025-09-01 11:47:51 +02:00

README.md

PostgreSQL

Description

This Ansible role deploys and configures a PostgreSQL database in a Docker container using Docker Compose. It is designed to simplify database administration by automating the creation of networks, containers, and essential database tasks (such as database and user creation) for a secure and high-performance environment.

Overview

Built for environments that demand reliability and ease of management, this role:

Sets up a dedicated Docker network for PostgreSQL.
Deploys a PostgreSQL container with secure configurations and automated healthchecks.
Automates tasks like database creation, user setup, and privilege assignments to streamline your workflows.

Purpose

The purpose of this role is to provide an effortless way to deploy a PostgreSQL database via Docker. It minimizes manual interventions while ensuring that your database is configured securely and reliably for both production and development scenarios.

Features

Automated Deployment: Installs PostgreSQL with minimal manual steps.
Robust Administration: Automatically creates databases, users, and assigns privileges.
Enhanced Security: The service is bound to 127.0.0.1:5432, restricting access and enhancing security.
Seamless Docker Integration: Works harmoniously with Docker Compose and other roles in your infrastructure.

Credits 📝

Developed by Kevin Veen-Birkenbach.
Discover more at www.veen.world
Part of the Infinito.Nexus Project
License: Infinito.Nexus NonCommercial License