This entry guides you through the steps to create a Postgresql connection pool on the Ambience/Repertoire 202x server.
-
Deploy the Postgresql driver in the \lib or \ext directory of the Ambience/Repertoire 202x installation.
Do refer to the following link to get a copy of the JDBC driver if required. -
Go to \etc directory, make a copy and rename hikari-sample.properties, e.g. postgresql.properties
-
Edit the mssql.properties file as follows:
**Do edit the values as required.
dataSourceClassName=org.postgresql.ds.PGSimpleDataSource
dataSource.user=<username>
dataSource.password=<encrypted-password>
dataSource.databaseName=<dbname>
dataSource.portNumber=<port>
dataSource.serverName=<servername>
dataSource.url=jdbc:postgresql://<hostname>:<port>/<dbname>
- If you wish to declare the schema name, revise the parameter value for dataSource.url as follows:
dataSource.url=jdbc:postgresql://<hostname>:<port>/<dbname>?currentSchema=<schemaName>
- Do refer to the following entry on how to encrypt your plain-text passwords:
Encrypting using Ambience/Repertoire 202x
- Edit the application.conf file to point to the Postgresql connection properties. Substitute “sample” with the actual database name e.g.
elixir.data.jdbc {
connection-pool {
implementation = “hikari”
definition {
sample = “./etc/postgresql.properties”
}
}
}
-
Restart the Ambience/Repertoire server.
-
If successful, the following message would be logged in your ambience/repertoire logs:
- For a step-by-step guide and to test out the connection using a ETL Chain, do refer to the following documentation:
Configure Postgresql Connection Pool on Ambience_Repertoire 2023.docx.pdf