Configure the database for LiveContent Central on Windows
Perform the following steps to configure the database.
- Configure the Content Service.
- Open the application.yml file located at [LCC_home]/content-service/config for editing.
- Find the following configuration:
spring: datasource: host: localhost port: 5432Notice that ownership is demonstrated by indentation of exactly two spaces as described in the important note above. So host and port are both members of datasource, which itself is a member of spring.
You will notice that the values for host and port are the default values for PostgreSQL. If PostgreSQL is running on a different computer and/or port, update the application.yml file with your computer name instead of localhost and your port number that you have PostgreSQL running on. - Within the same file, find the following configuration:
Update the application.yml file with your user instead postgres and password instead of postgres that you use to connect to PostgreSQL.spring: liquibase: user: postgres password: ENC(your_encrypted_password)
- Repeat step 1 to configure the database for the following services.
- Publish Service
- Distribution Service
- Discovery Service
- Deployer Service
- Verify that the correct path to the parent directory of pg_dump and psql binaries have been set in the application.yml file for Content service and Distribution service. For example.
baseDir: /path to postgres/bin
If you are installing LiveContent Central in a distributed environment and PostgreSQL is configured on a remote system, refer to the PostgreSQL official documentation website for information about client authentication and updating the pg_hba.conf file.