PostgreSQLYou need to create a separate user flexbi_private with database creation rights for flex.bi: Code Block |
---|
CREATE ROLE flexbi_private PASSWORD 'secret' LOGIN CREATEDB; |
If you do not want to add the CREATEDB role to the flexbi_private user then manually create the flexbi_private database with flexbi_private user as the owner. Each new flex.bi account will store data in a new flexbi_jira_dwh_N schema (where N is account ID number) in the same database. Please tune PostgreSQL memory parameters. The following postgresql.conf settings are recommended: Code Block |
---|
shared_buffers = 1024MB
wal_buffers = 32MB |
The parameter shared_buffers will specify how much database data PostgreSQL can store in the memory - adjust it to your available server memory (the more data PostgreSQL will store in the memory the less disk input/output operations will be performed). The parameter wal_buffers affects the performance of writing transaction logs to disk.
|