Postgres

​

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

​

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.