Configuring Amazon RDS PostgreSQL as the Backend Database

PAM360 allows users to configure Amazon RDS PostgreSQL as the backend database. Amazon RDS is an open sourced, fully managed relational database. Amazon RDS comes with a set of features such as easy and managed deployments, dynamic scaling, automated backups, etc.

Here, in this document, you will learn how to configure the Amazon RDS PostgreSQL as the backend database.

Steps Required

  1. Download and install PAM360 in a AWS EC2 instance.
  2. Create an RDS PostgreSQL database in AWS.
  3. Now, make a copy of the below files under <PAM360_Installation_folder>\conf directory and rename them:
    • customer-config.xml to customer-config_old.xml.
    • database_params.conf to database_params_old.conf.
  4. Open database_param.conf file.
    • Replace localhost with the hostname of the PostgreSQL server running in AWS.
    • Change the port number to the actual port number of the PostgreSQL instance in AWS.
    • Set SSL=true and provide the user details that were used to restore the dump file to the database.
    • Give the user details that were created while database creation in RDS/ Create a new user in RDS and add it to the super user group.
  5. Open customer-config.xml and search for startdbserver= true and change its value to false.
  6. Import the root .pem file into PAM360.
  7. Start the PAM360 service.

You have successfully configured Amazon RDS PostgreSQL Database as the backend database.
Top