Database

Note: All of the following config options can be set in /etc/sicura/sicura-console.yaml

Configuring the Database connection¶

There is no default database so you must define a PostgreSQL connection string in sicura-console.yaml using one of the following formats:

Put the host, port, and database name in the connection URL itself, and supply the credentials through main.database.options:

main.database: postgres://ip_address:port/database
main.database.options:
 user: user
 password: password

Set main.database to just the postgres:// scheme and supply every connection detail as its own key under main.database.options:

main.database: "postgres://"
main.database.options:
 user: user
 password: password
 host: ip_address
 port: port
 database: database

You can specify additional general and PostgreSQL specific options using main.database.options.