Increasing the work_mem value increases performance and allows PostgreSQL to perform larger in-memory sorting. Review your memory requirements in work_mem in the nf file in your PostgreSQL directory. If there are multiple Sync Service instances forming a cluster hidden behind a load balancer, max_connections should be greater than or equal to the sum of all db.pool.max from all config.yml files.įor example, if max_connections=450, and there are 3 Sync Service instances, then the correct setting in config.yml is db.pool.max : 150. So, the value of the db.pool.max property in the config.yml file must be less than or equal to 100. If max_connections is left unchanged, bear in mind that in the PostgreSQL database, the default max_connections is 100. Windows: C:\Program Files\PostgreSQL\9.4\data\nfĪdd or edit the max_connections property: max_connections = 450.Increase the maximum connections setting in the PostgreSQL configuration file.
#POSTGRES CREATE DATABASE DRIVER#
See step Starting the Sync Service.ĭownload the appropriate driver that’s compatible with JDBC42 from the PostgreSQL JDBC Driver download page.Ĭopy the JAR file into the same directory as the Sync Service JAR. The Sync Service isn’t packaged with a PostgreSQL driver, so it’ll need to be downloaded separately and cited in the start-up. The repository doesn’t communicate with the database. It persists events taken from the JMS queue into the database. Note: Only the Sync Service communicates with the database.
Alfresco recommends that you use a separate PostgreSQL instance for the Sync Service.
0 kommentar(er)
