45 lines
1.2 KiB
Bash
45 lines
1.2 KiB
Bash
# PostgreSQL data
|
|
PGDATA=/var/lib/postgresql/18/docker
|
|
|
|
# Bootstrap behavior:
|
|
# primary = initialize a new primary
|
|
# standby = clone a new standby
|
|
# existing = adopt an already-existing PostgreSQL data directory
|
|
POSTGRES_HA_MODE=primary
|
|
|
|
POSTGRES_NODE_NAME=DAVID-ELITEDESK
|
|
|
|
# Initial database/admin account
|
|
POSTGRES_DB=david
|
|
POSTGRES_USER=david
|
|
|
|
# Replication
|
|
POSTGRES_REPLICATION_USER=replicator
|
|
POSTGRES_REPLICATION_SLOT=ha_david_elitedesk
|
|
POSTGRES_APPLICATION_NAME=DAVID-ELITEDESK
|
|
|
|
# Used by standby mode
|
|
POSTGRES_PRIMARY_HOST=192.168.1.6
|
|
POSTGRES_PRIMARY_PORT=5432
|
|
|
|
# Networks allowed to perform streaming replication
|
|
POSTGRES_HA_CIDR=192.168.1.0/24
|
|
|
|
# PostgreSQL HA settings
|
|
POSTGRES_WAL_LEVEL=replica
|
|
POSTGRES_MAX_WAL_SENDERS=10
|
|
POSTGRES_MAX_REPLICATION_SLOTS=10
|
|
POSTGRES_HOT_STANDBY=on
|
|
|
|
# Bootstrap state
|
|
POSTGRES_BOOTSTRAP_MARKER=.loxthelion-ha-initialized
|
|
|
|
# Mounted secret locations
|
|
POSTGRES_PASSWORD_FILE=/run/secrets/postgres-ha/postgres_password
|
|
POSTGRES_REPLICATION_PASSWORD_FILE=/run/secrets/postgres-ha/replication_password
|
|
|
|
# Physical replication slots expected on every writable primary
|
|
POSTGRES_HA_SLOTS=ha_david_elitedesk,ha_david_dv6
|
|
POSTGRES_PASSWORD=<REDACTED>
|
|
POSTGRES_REPLICATION_PASSWORD=<REDACTED>
|