Last updated
Was this helpful?
Last updated
Was this helpful?
Database settings
Database host address.
Database port.
The database name. postgres
name is not allowed.
The database username.
A password of database role name.
Automatically installs PostgreSQL extensions (pgcrypto, unaccent, pg_trgm, fuzzystrmatch) during server startup.
Schema for PostgreSQL extensions. Default is current schema.
Maximum wait time (in milliseconds) for a database connection from the pool before timing out.
Specifies a SQL statement that will be executed after every new connection creation before adding it to the pool.
Maximum timeout (in milliseconds) to close idle connection.
Minimum number of connections.
Maximum number of simultaneous database connections.
ID
db.host
Type
String
Default value
(no default)
Environment variables
BOX_DB_HOST
,
PGHOST
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Environment variables
Hot reload
false
— setting requires system restart
ID
db.port
Type
Int
Default value
5432
Environment variables
BOX_DB_PORT
,
PGPORT
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Environment variables
Hot reload
false
— setting requires system restart
ID
db.database
Type
String
Default value
(no default)
Environment variables
BOX_DB_DATABASE
,
PGDATABASE
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Environment variables
Hot reload
false
— setting requires system restart
ID
db.user
Type
String
Default value
(no default)
Environment variables
BOX_DB_USER
,
PGUSER
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Environment variables
Hot reload
false
— setting requires system restart
ID
db.password
Type
String
Default value
(no default)
Environment variables
BOX_DB_PASSWORD
,
PGPASSWORD
Sensitive
true
— value will be masked in Admin UI
Set via
Environment variables
Hot reload
false
— setting requires system restart
ID
db.install-pg-extensions
Type
Bool
Default value
true
Environment variables
BOX_DB_INSTALL_PG_EXTENSIONS
,
AIDBOX_INSTALL_PG_EXTENSIONS
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Environment variables
Hot reload
false
— setting requires system restart
ID
db.extension-schema
Type
String
Default value
(no default)
Environment variables
BOX_DB_EXTENSION_SCHEMA
,
AIDBOX_EXTENSION_SCHEMA
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Admin UI → Settings Environment variables
Hot reload
false
— setting requires system restart
ID
db.pool.connection-timeout
Type
Int
Default value
30000
Environment variables
BOX_DB_POOL_CONNECTION_TIMEOUT
,
BOX_DB_POOL_CONNECTION__TIMEOUT
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Admin UI → Settings Environment variables
Hot reload
false
— setting requires system restart
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
— value will be visible in plaintext in Admin UI
Set via
Admin UI → Settings Environment variables
Hot reload
false
— setting requires system restart
ID
db.pool.idle-timeout
Type
Int
Default value
10000
Environment variables
BOX_DB_POOL_IDLE_TIMEOUT
,
BOX_DB_POOL_IDLE__TIMEOUT
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Admin UI → Settings Environment variables
Hot reload
false
— setting requires system restart
ID
db.pool.minimum-idle
Type
Int
Default value
0
Environment variables
BOX_DB_POOL_MINIMUM_IDLE
,
BOX_DB_POOL_MINIMUM__IDLE
Sensitive
false
— value will be visible in plaintext in Admin UI
Set via
Admin UI → Settings Environment variables
Hot reload
false
— setting requires system restart
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
— value will be visible in plaintext in Admin UI
Set via
Admin UI → Settings Environment variables
Hot reload
false
— setting requires system restart