Intro

Find out more about Postgres here.

Necessary Credentials

  • Hostname

    • The server where your database lives

    • Example: rds.amazonaws.com

  • Port

    • The port the database server uses

    • Example: 5432

  • Database name

    • Name of the database you are connecting Explo to
    • Example: acme_production
  • Authentication

    • Scheme you want to use (options below)

Authentication Options

Username and Password

  • Credentials:

    • Username

    • Password

AWS IAM Authentication

  • Make sure your created IAM user has the necessary privileges in your database to let Explo read your tables.
  • To create an IAM user, see here
  • Credentials:
    • Username
    • AWS Region
    • AWS Access Key ID
    • AWS Secret Key
    • SSL Cert

Allowlisting Explo’s IPs

You may need to allowlist egress IPs for your Connectivity Region.

SSH Tunnels

You can connect to Postgres databases via an SSH tunnel if necessary. Check out this section on SSH tunnels to see how.

Questions?

Please reach out to the Explo team at [email protected] if you have any questions.