> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Azure PostgreSQL source for ELT & CDC

> Configure Azure Database for PostgreSQL as a source in Integrate.io ELT & CDC. Enable LOGICAL replication and complete the common PostgreSQL setup.

This page covers the **Azure-specific** steps to prepare your PostgreSQL instance for ELT & CDC. After completing them, follow the common setup (sync user grants, heartbeat table, publication, and replication slot) on the [PostgreSQL source for ELT & CDC](/cdc/postgresql) page.

## Requirements

* Azure Single Server for PostgreSQL.
* PostgreSQL **version 10 or above**.
* Connect to the **primary** instance. Logical replication only works on the primary.
* Tables with a `PRIMARY KEY`.

## Enable logical replication

<Steps>
  <Step title="Open the Azure Database for PostgreSQL server">
    Go to your Azure Database for PostgreSQL server page in the Azure portal.
  </Step>

  <Step title="Set replication support to LOGICAL">
    Under **Replication**, set replication support to **LOGICAL** and click **Save**. Restart the server if Azure prompts you.

    <Frame>
      <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-86.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=408a2bb8609ddc727cd325b49aefc7f5" alt="Azure PostgreSQL replication settings with LOGICAL support enabled" width="1638" height="718" data-path="images/cdc/sources/image-86.png" />
    </Frame>
  </Step>
</Steps>

## Next: common setup

Continue with the canonical PostgreSQL setup for the remaining steps — sync user creation, privileges (`USAGE`, `SELECT`, `REFERENCES`), heartbeat table, publication, and replication slot. Grant the replication attribute with `ALTER ROLE integrateio WITH REPLICATION;`.

<Card title="PostgreSQL source for ELT & CDC" icon="arrow-right" href="/cdc/postgresql" horizontal />

<CardGroup cols={2}>
  <Card title="SSH Tunnel" icon="arrow-right" href="/cdc/ssh-tunnel" horizontal />

  <Card title="PostgreSQL PrivateLink" icon="arrow-right" href="/cdc/postgresql-privatelink-set-up" horizontal />
</CardGroup>