agentic-stacks /

postgresql

v2026.0407.1

Agent-driven PostgreSQL deployment and operations covering the full lifecycle: installation, configuration, high availability, backup/restore, performance tuning, security, and day-two operations across bare metal, containerized, and Kubernetes environments.

Install:

pipx install agentic-stacks  # if you haven't already
agentic-stacks pull agentic-stacks/postgresql

Skills

concepts

PostgreSQL architecture, process model, MVCC, WAL, storage layout

installation

Installing PostgreSQL on bare metal/VM (apt, yum, source) and Docker/Podman

configuration

postgresql.conf, pg_hba.conf, resource tuning baselines, SSL/TLS setup

standalone

Single-server production deployment — init, config, verification

containerized

Docker/Podman deployment patterns, volumes, networking, compose

kubernetes

CloudNativePG, Crunchy PGO, Zalando operator deployment and management

replication

Streaming replication, logical replication, cascading, synchronous modes

ha

Patroni + etcd/Consul HA clusters, automatic failover, fencing

connection-pooling

PgBouncer, PgCat — installation, configuration, pool modes

observability

pg_stat views, Prometheus/pg_exporter/Grafana, pgBadger, pgAudit

security

Roles/privileges, RLS, LDAP/SCRAM auth, pgcrypto, encryption, compliance patterns

backup-restore

pgBackRest, pg_dump/pg_restore, pg_basebackup, Barman, PITR

upgrades

Minor upgrades, pg_upgrade major version, logical replication upgrade path

health-check

Cluster validation — connections, replication, disk, locks, bloat

performance

postgresql.conf tuning, EXPLAIN analysis, indexing, partitioning, vacuum tuning, pgbench

schema-management

Migration tools (Flyway, sqitch, Alembic, golang-migrate), schema diffing, patterns

troubleshooting

Symptom-based diagnostic decision trees — connections, slow queries, replication, crashes

decision-guides

Comparison matrices for HA, backup tools, K8s operators, migration tools, poolers, auth methods

compatibility

PostgreSQL version × OS × extension × tooling compatibility

known-issues

Version-specific bugs, caveats, and workarounds for PG 16 and 17