Sign up for FreeKnowledge Base

Installing an RDS Database

How to install an AWS RDS database to P0

Before you begin 📋

  • Target RDS PostgreSQL instance with IAM Authentication enabled

  • Permissions to manage AWS IAM and network resources:

    • Create Roles, Attach Policies, and manage Trust Relationships

    • For Private Endpoints: Create Lambda functions, VPC Endpoints, and Security Groups

  • Permissions to connect to the RDS instance, as a user with CREATEROLE and CREATE privileges:

    • Create users and roles (CREATE ROLE)

    • Create stored procedures (CREATE FUNCTION)

    • Grant role membership and execute permissions (GRANT, EXECUTE)

  • Network accessibility via Public Endpoint (if RDS is public), or an existing AWS Security Perimeter integration in P0 in the VPC that RDS instance is in (for private RDS)

  • RDS Resource ID (available in the AWS Console Configuration tab)

  • An existing AWS IAM management integration in P0 for the linked RDS database account.

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.

  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

PreviousInstalling an CloudSQL DatabaseNextRequesting Access

Last updated