Page Comparison

...

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 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. 

...

1. Use the scripts given in the following locations to change the respective database and then restart the server.

   • To create tables for the registry and user manager database, use the below script:

     Code Block
     language powershell
     <PRODUCT_HOME>/dbscripts/postgresql.sql

   • To create tables for the RSS meta data repository database, use the below script:

     Code Block
     language powershell
     <PRODUCT_HOME>/dbscripts/rss-manager/postgresql/wso2_rss_postgresql.sql

2. Start the WSO2 product instance as follows:
   

   • For Linux:

     wso2server.sh

   • For Windows:

     wso2server.bat

Using a startup parameter

...