Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Pageshared:Setting Up PostgreSQLshared:Setting Up PostgreSQLThe following sections describe how to replace the default H2 databases with PostgreSQL: 

Table of Contents
maxLevel3
styleborder:1
locationtop
separatorpipe

Include Page
Shared:Setting up PostgreSQL (V1)
Shared:Setting up PostgreSQL (V1)

Changing the BPS database

The topics above show how to change the WSO2_CARBON_DB, which is used to store registry and user manager information. If you changed the BPS database that comes by default, the instructions are the same. In summary:

  1. Add the datasource to the master-datasources.xml file. Change its elements with your custom values.

    Create the database tables using the following scripts:

    For the BPS database

    Use <PRODUCT_HOME>/dbscripts/bps/postgresql.sql