nextstage/stack-postgresql repository overview

⁠PostgreSQL HA Stack Installer

⁠Installation

Requirements:

• The target installation directory must not exist before execution.
• Mount your target path to /stack.

Run:

sudo docker run --rm --pull always \
  -v /your/path/to/install/postgresql-stack:/stack \
  nextstage/stack-postgresql

Notes:

• The installer generates strong runtime passwords for postgres and replicator.
• Generated values are written to the stack environment files.
• If you replace them, keep strong passwords for both users.

⁠Usage

After installation, use scripts in /scripts:

• /scripts/_init.sh: loads shared shell helper functions.
• /scripts/dump.sh: creates backup dumps with pg_dump.
• /scripts/start.sh: starts the stack with required permissions and compose setup.
• /scripts/createDatabaseAndUser.sh: creates a new database and user.
• /scripts/menu.sh: opens an interactive menu with available container scripts.
• /scripts/menu.sh <optional_param>: runs one embedded script directly (parameter = script name without .sh).
  • Available params: addReadonlyUser, auditTriggerCreator, changePasswordUser, createDatabase, dropUser, duplicate, grantAllOnTablespaceIndexes, healthcheck, install-pgai, moveIndexesToTablespace, promoteToMaster, reloadConfig, replicatorCreateOrUpdateUser, restoreOriginalConfig.