Configure the database for LiveContent Central on Windows

Perform the following steps to configure the database.

To configure the database, do the following:
  1. Configure the Content Service.
    1. Open the application.yml file located at [LCC_home]/content-service/config for editing.
    2. Find the following configuration:
      spring:
        datasource:
          host: localhost
          port: 5432

      Notice 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.
    3. Within the same file, find the following configuration:
      spring:
        liquibase:
          user: postgres
          password: ENC(your_encrypted_password)
      Update the application.yml file with your user instead postgres and password instead of postgres that you use to connect to PostgreSQL.
  2. Repeat step 1 to configure the database for the following services.
    1. Publish Service
    2. Distribution Service
    3. Discovery Service
    4. Deployer Service
    You will find the corresponding application.yml files under [LCC_Home]/<servicename>/config
  3. 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.