Microsoft Azure Database for PostgreSQL - Flexible Server

[brentadonis]

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?

[john_wang · Accepted solution]

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.

[brentadonis]

Hello John,

Thank you for the response - much appreciated.