PostgreSQL
Last updated
Was this helpful?
Last updated
Was this helpful?
When using the PostgreSQL app driver, first configure your PostgreSQL connection credentials using :
DB_POSTGRES_HOST
127.0.0.1
Any string
The PostgreSQL host.
DB_POSTGRES_PORT
3306
Any integer
The PostgreSQL port.
DB_POSTGRES_USERNAME
root
Any string
The PostgreSQL username.
DB_POSTGRES_PASSWORD
password
Any string
The PostgreSQL password.
DB_POSTGRES_DATABASE
main
Any string
The PostgreSQL database.
This database supports .
Once you have configured your PostgreSQL database credentials, you should create a table with the following structure:
The following environment variables are used to define the behavior of the PostgreSQL app driver:
APP_MANAGER_POSTGRES_TABLE
apps
Any string
The table to pull the app data from.
APP_MANAGER_POSTGRES_VERSION
13.3
Any string
The PostgreSQL version (utilized by the underlying Knex database abstraction layer).
This feature is truly optional. To enforce app-level limits in PostgreSQL, you should add the following fields to your table:
Existing apps running on <0.29.0
will still work even if you don't have these fields added after the migration to 0.29.0
. You should add these fields to keep your database up-to-date or to have the choice to, later on, imply limits to your apps.
Setting any of them to null
or ''
will ignore the setting, and use the limits associated .