pgdump
The pgdump running mode executes either a pg_dump or pg_dumpall database backup against another PostgreSQL database.
MODE: pgdump
Environment Variables
Required
| Name | Default | Description |
|---|---|---|
| MODE | None | Set to pgdump to run as pg_dump job |
| PGDUMP_DB | None | Name of the database the backup is being performed on. |
| PGDUMP_HOST | None | Hostname of the database the backup is being performed on. |
| PGDUMP_PASS | None | Password for the PostgreSQL role being used. |
| PGDUMP_USER | None | Username for the PostgreSQL role being used. |
Optional
| Name | Default | Description |
|---|---|---|
| PGDUMP_ALL | TRUE | Run pg_dump instead of pg_dumpall. Set to false to enable pg_dump. |
| PGDUMP_CUSTOM_OPTS | None | Advanced options to pass into pg_dump or pg_dumpall. |
| PGDUMP_FILENAME | dump | Name of the file created by the pgdump container. |
| PGDUMP_PORT | 5432 | Port of the PostgreSQL database to connect to. |
| CRUNCHY_DEBUG | FALSE | Set this to true to enable debugging in logs. Note: this mode can reveal secrets in logs. |
For a list of advanced options for configuring the PGDUMP_CUSTOM_OPTS variable, see the official documentation:
https://www.postgresql.org/docs/current/static/app-pgdump.html
https://www.postgresql.org/docs/current/static/app-pg-dumpall.html
Dump Location
Backups are stored in a mounted backup volume location, using the database host name plus -backups as a sub-directory, then followed by a unique backup directory based upon a date/timestamp. It is left to the user to perform database backup archives in this current version of the container. This backup location is referenced when performing a database restore.