Installing an RDS Database

How to install an AWS RDS database to P0

Before you begin

This guide will walk you through Adding an RDS PostgreSQL Database to P0. In order to begin you must have already installed the AWS Integration in P0 for the account that the RDS database is in. The database must also be configured with IAM Authentication as below

Install the RDS Database

1. Go to p0.app in your browser, navigate to Integrations, and select PostgreSQL.

1. Scroll to the Resources section and search for “Access management”

   
2. Click “Add Resource” to install a new database.

1. On the following page choose any Database Identifier, which will be used to identify the database in P0

The Database identifer cannot be changed after installation. To change the database identifier the database must be uninstalled from P0 and reinstalled with a new identifier.

1. Scroll down to the AWS RDS radio button and select it, then fill out the remaining options

The Resource ID is distinct from the Instance ID and can be located in the Configuration tab of the database in the AWS Management Console (See below)

1. Follow the provided instructions to provision access using AWS CloudShell. This step grants P0 permission to run commands in your RDS Database

1. Follow the remaining instructions in your RDS database logged in as a user with the permissions listed in the instructions, then click Next at the bottom of the page. This step creates the stored procedures that P0 will used to grant permissions to users in your database.

1. On the summary page that appears, scroll to the bottom and click Finish

1. P0 is now installed on your RDS database and you can make an access request