topic Re: Endpoint setup for PostgreSQL Flexible server on Azure in Qlik Replicate

Endpoint setup for PostgreSQL Flexible server on Azure

eksmirnova — Thu, 08 Jun 2023 20:20:59 GMT

Hi everyone,

We need to setup a new source endpoint for PostgreSQL flexible server on Azure.

I check documentation and found only Capturing changes from Microsoft Azure for PostgreSQL.

Is there any difference in the requirements on the source side since it is Flexible server?

Our Postgres DBA saying there is no pg_hba.conf configuration file where he can add the IP adress of the Qlik machine.

Re: Endpoint setup for PostgreSQL Flexible server on Azure

john_wang — Fri, 09 Jun 2023 01:47:58 GMT

Hello @eksmirnova ,

Welcome to community again!

I do not think so there are major differences in the requirements however it's some different in some places, eg file "pg_hba.conf" is invisible in Flexible Server because Azure Database for PostgreSQL is a managed database service, users are not provided host or OS access to view or modify configuration files. The content of the files is automatically updated based on the network settings. You DBA may manage that via the Azure portal I think.

Hope this helps.

Regards,

John.

Re: Endpoint setup for PostgreSQL Flexible server on Azure

eksmirnova — Tue, 13 Jun 2023 14:08:26 GMT

Hi @john_wang

Could you please provide more details how to configure the networks settings that manage the pg_hba.conf?

Re: Endpoint setup for PostgreSQL Flexible server on Azure

john_wang — Tue, 13 Jun 2023 14:48:04 GMT

Hello @eksmirnova ,

I'm afraid I have not too much experience on that, please check if this helps:

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-firewall-portal

Regards,

John.