Connecting to an Azure Database for PostgreSQL

This guide provides step-by-step instructions to connect your Azure Database for PostgreSQL to Sequin.

Provision a Postgres user for Sequin

When in development, it’s probably fine to supply Sequin with an existing user. However, when in production, you should create a dedicated user for Sequin. The user needs the following permissions:

connect permission on the database.
select permission on all the tables you want to connect to Sequin.
replication permission to read from replication slots.

Here’s how to create a dedicated user with the minimum required permissions:

-- Create user with a secure password
create user sequin_user with password 'REPLACE_WITH_SECURE_PASSWORD';

-- Grant connect permission
grant connect on database your_database to sequin_user;

-- Grant select permission on tables you want to replicate
grant select on table table1, table2, table3 to sequin_user;
-- OR grant select on all tables in a schema
grant select on all tables in schema public to sequin_user;

-- Grant replication permission
alter user sequin_user with replication;

To generate a secure password, if you have OpenSSL installed, you can use the following command:

openssl rand -base64 32

Enable logical replication on Azure Database for PostgreSQL

By default, logical replication is not enabled on Azure Database for PostgreSQL. You can double check if logical replication is enabled by connecting to your database and running the following command:

SHOW rds.logical_replication;

If the output is off, then logical replication is not enabled. To enable it, follow these steps:

Enabling replication requires a restart of your database server.

Configure server parameters

In the Azure Portal, navigate to your Azure Database for PostgreSQL server and follow these steps:

Go to the “Server parameters” page
Set the following parameters:
- wal_level: Set to logical
- shared_preload_libraries: Add pglogical to the list (if not already present)
- azure.extensions: Add pglogical to the list (if not already present)
- max_worker_processes: Set to at least 16
Click “Save” to apply the changes

Restart the server

After changing the server parameters, you need to restart your server for the changes to take effect. In the Azure Portal:

Go to the “Overview” page of your PostgreSQL server
Click the “Restart” button at the top of the page
Confirm the restart when prompted

Configure network access

Ensure that your Azure Database for PostgreSQL server allows network traffic from your connecting resource. You may need to add firewall rules or configure virtual network settings in the Azure Portal.Read more about how to setup logical replication in Azure Database for PostgreSQL here.

Connect Sequin to your Azure Database for PostgreSQL

After enabling logical replication on Azure Database for PostgreSQL, you’ll now connect to your database in Sequin.

Enter connection details in Sequin

In the Sequin Console, click on the “Connect Database” button and enter the credentials for your Azure Database for PostgreSQL:

You can find these connection details in your Azure Portal under the PostgreSQL server’s “Connection strings” section.

Host: Your Azure PostgreSQL server hostname
Port: 5432 (default Postgres port)
Database: Your database name
Username: The sequin database user you created earlier
Password: The password for your sequin database user

Make sure to enable the “SSL” option for secure connection.

Create a publication

Connect to your database using the SQL client of your choice and execute the following SQL query to create a publication:

CREATE PUBLICATION sequin_pub FOR TABLE table1, table2, table3 WITH (publish_via_partition_root = true);

If you want to publish changes from all tables, you can use:

CREATE PUBLICATION sequin_pub FOR ALL TABLES WITH (publish_via_partition_root = true);

Create a replication slot

Next, create a replication slot to capture changes from the publication:

SELECT pg_create_logical_replication_slot('sequin_slot', 'pgoutput');

Enter the replication slot details in Sequin

Back in the Sequin Console, enter the name of the replication slot (e.g. sequin_slot) and publication (e.g. sequin_pub) you just created. Then, name your database and click “Create Database”.

Create a sink

With your Azure Database connected to Sequin, you are ready to create a sink. Follow one of our guides below to get started:

Stream to Webhooks

Send database changes to your HTTP endpoints to trigger workflows and keep services in sync

Stream to Redis

Stream changes to Redis Streams for real-time data processing and caching

Stream to Kafka

Publish database changes to Kafka topics for event streaming and processing

Stream to SQS

Send changes to AWS SQS queues to trigger Lambda functions and other AWS services

Stream to GCP Pub/Sub

Send changes to GCP Pub/Sub topics to trigger Cloud Functions and power event-driven architectures

Get started

Sink setup guides

How-to guides

Concepts

Reference

Database setup guides

Tutorials

Connecting to an Azure Database for PostgreSQL

Provision a Postgres user for Sequin

Enable logical replication on Azure Database for PostgreSQL

Configure server parameters

Restart the server

Configure network access

Connect Sequin to your Azure Database for PostgreSQL

Enter connection details in Sequin

Create a publication

Create a replication slot

Enter the replication slot details in Sequin

Create a sink

Stream to Webhooks

Stream to Redis

Stream to Kafka

Stream to SQS

Stream to GCP Pub/Sub

​Provision a Postgres user for Sequin

​Enable logical replication on Azure Database for PostgreSQL

Configure server parameters

Restart the server

Configure network access

​Connect Sequin to your Azure Database for PostgreSQL

Enter connection details in Sequin

Create a publication

Create a replication slot

Enter the replication slot details in Sequin

​Create a sink

Stream to Webhooks

Stream to Redis

Stream to Kafka

Stream to SQS

Stream to GCP Pub/Sub

Provision a Postgres user for Sequin

Enable logical replication on Azure Database for PostgreSQL

Connect Sequin to your Azure Database for PostgreSQL

Create a sink