pgrestore
The restore running mode provides a means of performing a restore
of a dump from pg_dump or pg_dumpall via psql or pg_restore
to a PostgreSQL container database.
MODE: pgrestore
Environment Variables
Required
| Name | Default | Description |
|---|---|---|
| MODE | None | Set to pgrestore to run as pg_restore job |
| PGRESTORE_DB | None | Name of the database to connect to. |
| PGRESTORE_HOST | None | Hostname of the database to connect to. |
| PGRESTORE_PASS | None | Password for the PostgreSQL role being used. |
| PGRESTORE_USER | None | Username for the PostgreSQL role being used. |
Optional
| Name | Default | Description |
|---|---|---|
| PGDUMP_BACKUP_HOST | None | Hostname of the PostgreSQL server that was backed up by pgdump container. Used when restoring a backup to a new host. |
| PGRESTORE_BACKUP_TIMESTAMP | Empty | Timestamp of the backup to restore from. |
| PGRESTORE_CUSTOM_OPTS | Empty | Advanced options to pass into pg_restore. |
| PGRESTORE_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 `PGRESTORE_CUSTOM_OPTS` variable, see the [official documentation](https://www.postgresql.org/docs/current/static/app-pgrestore.html).
Dump-file Input Location
As the input files for crunchy-pgrestore, files generated by crunchy-pgdump are retrieved 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 restore database dump archives in this current version of the container.