mirror of
https://github.com/Dokploy/templates.git
synced 2026-06-29 11:05:35 +02:00
161053606f
* feat: add PostgreSQL with PgDog template Add postgres-pgdog template providing PostgreSQL database with PgDog connection pooler, load balancer, and horizontal scaling proxy. Modern alternative to PgBouncer with multi-threading support. - Configurable PostgreSQL (default: 18-alpine) and PgDog (default: v0.1.26) images - Optional admin interface on port 6433 - Includes healthcheck and dependency management * 🐛 fix(postgres-pgdog): add config mounts and fix postgres volume path - Add [[config.mounts]] for pgdog.toml and users.toml - Mount config files from ../files/ in docker-compose - Change postgres volume to /var/lib/postgresql (postgres 18+ standard) - Add explicit command with config paths to prevent warnings * 🐛 fix(postgres-pgdog): correct binary path and use default config locations - Mount configs to /pgdog/ (default WorkingDir) instead of /etc/pgdog/ - Remove explicit command (binary is /usr/local/bin/pgdog, not /pgdog/pgdog) - Use image's default CMD with default config paths * 🐛 fix(postgres-pgdog): remove invalid admin_port config field - Remove admin_port from [general] section (not a valid field) - Admin DB uses same port 6432 with special database name - Remove commented admin domain config * 🐛 fix(postgres-pgdog): enable external access via fixed port mapping - Add fixed port 6432:6432 to postgres-pgdog service - Remove HTTP domain config (incompatible with TCP protocol) - Add comment for internal-only option Fixes UnsupportedStartup errors when using domain config for PostgreSQL protocol access. * 🐛 fix(postgres-pgdog): use standard port format per convention - Change port mapping from '6432:6432' to '6432' format - Follows Dokploy template convention for port declarations - External access requires checking Dokploy UI for assigned host port * 📝 docs(postgres-pgdog): clarify port settings comment * 🐛 fix(postgres-pgdog): default to internal access with opt-in external port - Remove obsolete version field - Port mapping commented by default for security - Users uncomment to enable external access on port 6432
37 lines
726 B
TOML
37 lines
726 B
TOML
[variables]
|
|
postgres_user = "${username}"
|
|
postgres_password = "${password:32}"
|
|
postgres_db = "postgres"
|
|
pgdog_image = "ghcr.io/pgdogdev/pgdog:v0.1.26"
|
|
postgres_image = "postgres:18-alpine"
|
|
|
|
[[config.mounts]]
|
|
filePath = "pgdog.toml"
|
|
content = """
|
|
[general]
|
|
host = "0.0.0.0"
|
|
port = 6432
|
|
|
|
[[databases]]
|
|
name = "${postgres_db}"
|
|
host = "postgres"
|
|
port = 5432
|
|
"""
|
|
|
|
[[config.mounts]]
|
|
filePath = "users.toml"
|
|
content = """
|
|
[[users]]
|
|
name = "${postgres_user}"
|
|
database = "${postgres_db}"
|
|
password = "${postgres_password}"
|
|
"""
|
|
|
|
[config.env]
|
|
POSTGRES_USER = "${postgres_user}"
|
|
POSTGRES_PASSWORD = "${postgres_password}"
|
|
POSTGRES_DB = "${postgres_db}"
|
|
PGDOG_IMAGE = "${pgdog_image}"
|
|
POSTGRES_IMAGE = "${postgres_image}"
|
|
RUST_LOG = "info"
|