Materialize Documentation
s
Join the Community github/materialize

How to connect Azure Database for PostgreSQL to Materialize

Materialize can read data from Azure DB for PostgreSQL via the direct Postgres Source. Before you start, note that a database restart will be required after making the changes below.

  1. The Materialize instance will need access to connect to the upstream database. This is usually controlled by IP address. In your Azure portal, go to the Azure Database for PostgreSQL instance and under the “Connections security” section add your Materialize instance’s IP address to the allowed IP addresses list and click on the “Save” button.

    If you are using Materialize Cloud, you can follow these steps to get the static IP address of your instance.

  2. In the Azure portal or using the Azure CLI, enable logical replication for the PostgreSQL instance.

  3. Create a publication with the tables you want to replicate:

    CREATE PUBLICATION mz_source FOR TABLE table1, table2;
    

    The mz_source publication will contain the set of change events generated from the specified tables, and will later be used to ingest the replication stream.

For more information, see the Azure Database for PostgreSQL documentation.

Did this info help?
Yes No