sqlrunner
The sqlrunner running mode will use psql to issue specified queries, defined in SQL files, to your PostgreSQL database.
MODE: sqlrunner
Environment Variables
Required
| Name | Default | Description |
|---|---|---|
MODE |
None | Set to sqlrunner to run as SQL running job |
PG_HOST |
None | Hostname of the database the sql files will be run on. |
PG_PORT |
None | The port to use when connecting to the database. |
PG_DATABASE |
None | Name of the database the sql files will be run on. |
PG_USER |
None | Username for the PostgreSQL role being used. |
PG_PASSWORD |
None | Password for the PostgreSQL role being used. |
Custom Configuration
All queries from sql files in the /pgconf volume will be issued to the specified PG_DATABASE.