|
|
Create a database user which BellaDati will connect as (e.g. belladati_dbuser
). Remember this database user name, as it will be used to configure BellaDati's connection to this database in subsequent steps. Do not forget to configure the pg_hba.conf
file, which controls the database access.
$ createuser -sDRP belladati_dbuser |
Create a database for BellaDati to be used as data warehouse (e.g. belladati_db
) with Unicode collation.
CREATE DATABASE belladati_db WITH ENCODING 'UNICODE' TEMPLATE template0; |
Or from the command-line:
$ createdb -E UNICODE -O belladati_dbuser belladati_db -T template0 |
Check if your database has the plpgsql language. If not, you can define it using command below(template0 has plpgsql installed so belladati_db database inherits it:
Or from the command line (this option is no longer available since PostgreSQL 10. Use command above):
|
Remember the database name; it will be used to configure BellaDati's connection to the database in the applications server configuration. |
We strongly recommend performing the following PostgreSQL configuration changes in $POSTGRES_HOME/data/postgresql.conf
. This example specifies parameters when you run the BellaDati application and database on a single server with 4GB memory. 2GB are allocated for the BellaDati application server running on Java (using the -Xmx parameter). The rest should be available for the operating system and database server.
This configuration may change according to real usage needs. Example below shows the minimal configuration for single server installation. |
Name | Value | Description | Note |
---|---|---|---|
max_connections | 50 | Sets the maximum number of concurrent connections. | |
shared_buffers | 512MB | Sets the number of shared memory buffers used by the server. | min 1/4 RAM, 1/2 RAM recommended |
temp_buffers | 2MB | Sets the maximum number of temporary buffers used by each session. | per session |
work_mem | 16MB | Sets the maximum memory to be used for query workspaces. | min 16MB, RAM / 128 recommended |
maintenance_work_mem | 64MB | Sets the maximum memory to be used for maintenance operations. | min 64MB, RAM / 32 recommeneded |
max_stack_depth | 2MB | Sets the maximum stack depth, in kilobytes. | |
wal_buffers | 512kB | Sets the number of disk-page buffers in shared memory for WAL. | |
effective_cache_size | 1024MB | Sets the planner's assumption about the size of the disk cache. | RAM / 2 recommended |
log_statement | none | Sets the type of statements logged. | |
autovacuum | on | Starts the autovacuum subprocess. | |
autovacuum_analyze_scale_factor | 0.05 | Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples. | |
autovacuum_analyze_threshold | 10 | Minimum number of tuple inserts, updates, or deletes prior to analyze. | |
autovacuum_freeze_max_age | 200000000 | Age at which to autovacuum a table to prevent transaction ID wraparound. | |
autovacuum_max_workers | 5 | Sets the maximum number of simultaneously running autovacuum worker processes. | |
autovacuum_multixact_freeze_max_age | 400000000 | Multixact age at which to autovacuum a table to prevent multixact wraparound. | |
autovacuum_naptime | 15s | Time to sleep between autovacuum runs. | |
autovacuum_vacuum_cost_delay | 10ms | Vacuum cost delay in milliseconds, for autovacuum. | |
autovacuum_vacuum_cost_limit | 1000 | Vacuum cost amount available before napping, for autovacuum. | |
autovacuum_vacuum_scale_factor | 0.1 | Number of tuple updates or deletes prior to vacuum as a fraction of reltuples. | |
autovacuum_vacuum_threshold | 25 | Minimum number of tuple updates or deletes prior to vacuum. |
We recommend set the |
You can backup the BellaDati database using the PostgreSQL dump command:
pg_dump -U user -F c -v -f "path_to_dump/dump.backup" belladati_db |
To restore a backup, use the pg_restore
command:
pg_restore -v -c -O -d belladati_db -U user path_to_dump/dump.backup |
Installing BellaDati on Linux - continue Installing BellaDati on Linux, step "check that default ports"
continue installing the BellaDati.war application on your application server as described in: