Connecting to an Azure Database for PostgreSQL
How to connect Sequin 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:
To generate a secure password, if you have OpenSSL installed, you can use the following command:
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:
If the output is off
, then logical replication is not enabled.
To enable it, follow these steps:
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 tological
shared_preload_libraries
: Addpglogical
to the list (if not already present)azure.extensions
: Addpglogical
to the list (if not already present)max_worker_processes
: Set to at least16
- 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:
If you want to publish changes from all tables, you can use:
Create a replication slot
Next, create a replication slot to capture changes from the publication:
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
Was this page helpful?