topic Re: Microsoft Azure Database for PostgreSQL - Flexible Server in Qlik Replicate

Microsoft Azure Database for PostgreSQL - Flexible Server

brentadonis — Tue, 25 Jul 2023 14:18:54 GMT

The documentation for Supported Endpoint Microsoft Azure Database for PostgreSQL - Flexible Server states that is is supported via the PostgreSQL source endpoint. However,

it appears that some of the information is not valid for the PaaS offering in Azure A lot of the documentation states the use of super user role but this is reserved for MS Support. Will azure_pg_admin work and is it supported? Or will we have to go down the route of using an account with the superuser role?

Re: Microsoft Azure Database for PostgreSQL - Flexible Server

john_wang — Wed, 26 Jul 2023 05:32:04 GMT

Hello @brentadonis ,

Thanks for opening the article.

If you need to replicate the DDL operations , then the option "Capture DDL events" should be enabled:

With this setting, Replicate will CREATE EVENT TRIGGER in PostgreSQL. The needed privilege in PostgreSQL doc Only superusers can create event triggers:

So, by default, the superuser rule is required.

Or you may try to CREATE EVENT TRIGGER by superuser role then use regular replication role account to run the task, in this scenario please check Replicate User Guide section: Using an account without the "superuser" role.

Hope this helps.

Regards,

John.

Re: Microsoft Azure Database for PostgreSQL - Flexible Server

brentadonis — Wed, 26 Jul 2023 09:34:04 GMT

Hello John,

Thank you for the response - much appreciated.