Page History
...
- Download the PostgreSQL JDBC driver from http://jdbc.postgresql.org/download.html. (Obtain version 9.0 of the JDBC 4 driver.)
- Add the PostgreSQL JDBC driver jar to the
lib/
directory of your application server.
4. PostgreSQL configuration
We are strongly recommending to perform the following PostgreSQL configuration changes in $POSTGRES_HOME/data/postgresql.conf
. Settings depend on your memory amount. This example specifies parameters when you are running BellaDati and database on a single server with 4GB memory. 2GB of the are allocated for BellaDati application server running on JAVA (the -Xmx parameter). The rest should be available for operating system and database server.
Name | Value | Note |
---|---|---|
max_connections | 100 |
|
shared_buffers | 512MB | min 1/4 RAM |
temp_buffers | 2MB | per session |
work_mem | 10MB | per client connection |
maintenance_work_mem | 64MB |
|
max_stack_depth | 2MB |
|
wal_buffers | 128kB |
|
effective_cache_size | 512MB |
|
5. Next steps
Continue configuring BellaDati WAR for your application server as described on:
...