Database

Database settings

Database host

Database host address.

ID	db.host
Type	String
Default value	(no default)
Environment variables	BOX_DB_HOST , PGHOST
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Database port

Database port.

ID	db.port
Type	String
Default value	(no default)
Environment variables	BOX_DB_PORT , PGPORT
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Database name

The database name. postgres name is not allowed.

ID	db.database
Type	String
Default value	(no default)
Environment variables	BOX_DB_DATABASE , PGDATABASE
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Database user

The database username.

ID	db.user
Type	String
Default value	(no default)
Environment variables	BOX_DB_USER , PGUSER
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Database password

A password of database role name.

ID	db.password
Type	String
Default value	(no default)
Environment variables	BOX_DB_PASSWORD , PGPASSWORD
Sensitive	true — can be set only via environment variable
Hot reload	false — requires Aidbox restart

Install PostgreSQL extensions at startup

Install PostgreSQL extensions at startup: pgcrypto, unaccent, pg_trgm, fuzzystrmatch.

ID	db.install-pg-extensions
Type	Bool
Default value	true
Environment variables	BOX_DB_INSTALL_PG_EXTENSIONS , AIDBOX_INSTALL_PG_EXTENSIONS
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Database extension schema

Schema for PostgreSQL extensions. Default is current schema.

ID	db.extension-schema
Type	String
Default value	(no default)
Environment variables	BOX_DB_EXTENSION_SCHEMA , AIDBOX_EXTENSION_SCHEMA
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Pool connection timeout

Maximum wait time (in milliseconds) for a database connection from the pool before timing out.

ID	db.pool.connection-timeout
Type	Int
Default value	30000
Environment variables	BOX_DB_POOL_CONNECTION_TIMEOUT , BOX_DB_POOL_CONNECTION__TIMEOUT
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Pool connection init SQL

Specifies a SQL statement that will be executed after every new connection creation before adding it to the pool.

ID	db.pool.connection-init-sql
Type	String
Default value	select 1
Environment variables	BOX_DB_POOL_CONNECTION_INIT_SQL , BOX_DB_POOL_CONNECTION__INIT__SQL
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Pool idle timeout

Maximum timeout (in milliseconds) to close idle connection.

ID	db.pool.idle-timeout
Type	Int
Default value	10000
Environment variables	BOX_DB_POOL_IDLE_TIMEOUT , BOX_DB_POOL_IDLE__TIMEOUT
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Pool minimum idle

Minimum number of connections.

ID	db.pool.minimum-idle
Type	Int
Default value	0
Environment variables	BOX_DB_POOL_MINIMUM_IDLE , BOX_DB_POOL_MINIMUM__IDLE
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart

Pool size

Maximum number of simultaneous database connections.

ID	db.pool.maximum-pool-size
Type	Int
Default value	8
Environment variables	BOX_DB_POOL_MAXIMUM_POOL_SIZE , BOX_DB_POOL_MAXIMUM__POOL__SIZE
Sensitive	false — can be set via Ul and environment variable
Hot reload	false — requires Aidbox restart