MainSourcesPg

PostgreSQL Setup

Prerequisites

Before you begin, ensure you have:

  • Supported PostgreSQL Version: PostgreSQL version 9.4 or higher.
  • Database Admin Access: Sufficient privileges to create users, grant permissions, and modify database configuration parameters. This might require superuser privileges or specific cloud provider roles (e.g., rds_superuser on AWS RDS, azure_pg_admin on Azure).
  • Network Connectivity: Ensure that Supermetal's services can reach your PostgreSQL database. You may need to configure firewall rules, security groups, or VPC peering.

Setup

Supermetal supports two replication types for PostgreSQL sources:

  • Snapshot: One-time or periodic full table snapshots.
  • Logical Replication: Real-time change data capture (CDC) with initial snapshot.

Last updated on

On this page

PrerequisitesSetupCreate Read-Only UserGrant Table AccessConfigure PostgreSQL Source in SupermetalConfigure User and PermissionsCreate Replication UserGrant Table AccessConfigure Replication Settings (WAL)Understanding WAL SettingsPlatform-Specific ConfigurationConfigure PublicationsConfigure PostgreSQL Source in Supermetal