The PostGreSQL database structure bring the family of Synergy SKY products together. Not only does it improve theperformance and reliability of the Synergy SKY products, but it improves the detection & processing of meetings. This database type stores historic meeting information that allows for better post sales support as well as the ability for the family of products from Synergy SKY to communicate together in unison.
By default, PostGreSQL is installed with the following database connection details:
Database name: synergyskydb
The database username or password can be changed through the PostGreSQL administration console or any other preferred database management tool. If any of these valued are changed, these will also have to be updated in the config.json file that can be located in the path - C:\SynergySKY\SynergySKYEnterpriseScheduling\config\ of your Synergy JOIN installation.
Allowing Synergy CONTROL & Synergy ANALYZE access to the Synergy JOIN database
Browse to the folder: C:\SynergySKY\SynergySKYEnterpriseScheduling\pqsqldb
Open the file ‘postgresql.conf’
Uncomment and Change the following lines to the below:
Note: To uncomment a line, you have to remove the '#' at the beginning of that line
CONNECTIONS AND AUTHENTICATION
listen_addresses = '*'
This will allow the PostGreSQL to listen for outside connections.
Browse to the folder: C:\SynergySKY\SynergySKYEnterpriseScheduling\pgsqldb
Open the file ‘pg_hba.conf‘.
# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 scram-sha-256
You have to replace 127.0.0.1/32 with the IP Address and IP Address range that your servers reside in.e.g. 192.168.10.0/24.
This will allow the PostGreSQL database to accept connections from addresses within the specified range. For increased security, the IP Address of the CONTROL and ANALYZE servers can be specified here using the following format