Configuring the PostgreSQL Database for PSC-EBX

To configure the PostgreSQL Database for PSC-EBX, perform the following steps:

    Procedure
  1. Start the PostgreSQL Database.

  2. Navigate to $PSC_HOME/db/postgresql/configure and modify the postgres_pscebx_db.properties file.

  3. Run the $PSC_HOME/db/postgresql/configure/doall.sh to run all the database scripts in one go.

  4. Uncomment and update the database details such as database url, username, password, and dataspace to the following section in the $PSC_HOME/ebx.properties file under ##Case EBX® persistence system is PostgreSQL:

    • ebx.persistence.factory=postgresql

    • ebx.persistence.url

    • ebx.persistence.driver

    • ebx.persistence.user

    • ebx.persistence.password

    Note: There are multiple occurrences of each of the property mentioned above. Comment all the other properties and there must be a single ebx.persistence.factory property, which points to the PostgreSQL database.