Canvas Docs
  • GETTING STARTED
    • Our docs have moved
    • Connect your data
      • App and database connectors
      • Snowflake
      • BigQuery
      • Redshift
      • Postgres
        • Use an SSH tunnel
      • Static IP Addresses
      • dbt
        • dbt Cloud
        • dbt via GitHub
    • Create your first canvas
    • Onboarding your team
  • Building canvases
    • Import data
    • Formulas
    • SQL
    • Joins
    • Pivot tables
    • Charts
    • Filters
      • Date filters
      • Text search filters
      • Multi-select filters
    • Canvas API
    • Events API
    • Embed Login API
  • Embeds
    • Public Embeds
    • Scopes
    • Walkthrough
    • PowerPoint embeds
  • Managing users
    • Assigning permissions
  • Security
    • Data security
    • Bug bounty program
    • Privacy policy
    • Terms of service
Powered by GitBook
On this page
  1. GETTING STARTED
  2. Connect your data
  3. Postgres

Use an SSH tunnel

If your Postgres instance is not accessible to the public, you can connect to it using an SSH tunnel

Prerequisites

  • The SSH tunnel host must be on the same network as your Postgres host.

Connecting using a tunnel

  1. Enter the hostname, port, and username of the ssh tunnel you would like to use.

  2. Copy the provided Public Key into the authorized_keys file in your SSH config for the username you provided.

    • Note: the provided Public Key is generated during setup, and is unique to every connection.

    • This means that if you have multiple SSH tunnels, you will have multiple public keys in your authorized_keys

PreviousPostgresNextStatic IP Addresses

Last updated 2 years ago