If the directory/file paths specified in this guide do not exist in your WSO2 product, see Directory Structure of WSO2 Products to locate the paths applicable to your product.

Versions Compared

Key

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

The following sections describe how to set up PostgreSQL to replace the default H2 databases with PostgreSQL:database in your WSO2 product: 

Table of Contents
maxLevel3
minLevel3
locationtop
styleborder:1
separatorpipe

...

hiddentrue

...

The following sections describe how to replace the default H2 databases with PostgreSQL:

Table of Contents
maxLevel3
locationtop
styleborder:1
separatorpipe

Setting up the database and login role

...

  1. Install PostgreSQL on your computer as follows:
  2. Start the PostgreSQL service using the following command:
  3. Create a database and the login role from a GUI using the PGAdminIII tool.
  4. To connect PGAdminIII to a PostgreSQL database server, locate the server from the object browser, right-click the client , and click Connect. This will show you the databases, tablespaces, and login roles as follows:
  5. To create a database, click Databases in the tree (inside the object browser), and click New Database.
  6. In the New Database dialog box, give a name to the database (for example: gregdb) and , e.g., gregdb and click OK.
  7. To create a login role, click Login Roles in the tree (inside the object browser), and click New Login Role. Enter the role name and a password.

    Info

    These values will be used in the product configurations as described in the following sections. In the sample configuration, gregadmin will be used as both the role name and the password.

  8. Optionally, enter other policies, such as the expiration time for the login and the connection limit.
  9. Click OK to finish creating the login role.

...

By default, all WSO2 products are configured to use the embedded H2 database. To configure your product with OraclePostgreSQL, see Changing to PostgreSQL.