question

85463781 avatar image
0 Votes"
85463781 asked NavtejSaini-MSFT answered

Is it possible to filter the access to Azure PostgreSQL by user+ip rather than just ip

I have already set firewall rules for Azure Postgresql and it works fine。

But i was told that in local Postgresql server,we can allow some users access in some clients by editting pg_hba.conf like this:

hostssl <databaseName> <userName> <clientIP> md5


I cannot find the way to edit the pg_hba.conf in Azure Portal.
So i want to confirm that is it possible in Azure Postgresql ? if yes,how to set?

Thank you!




azure-database-postgresqlazure-firewall-manager
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@85463781

We are checking this further and will get back to you.

Thanks
Navtej S

1 Vote 1 ·

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered

@85463781

As you already conveyed pg_hba.conf cannot be edited directly like in local Postgresql.

Also currently Setting IPs at a per user-scope is not currently supported. Please do leave the feedback here for the product team to look at and prioritize.

Please let us know if you have any other question.

Thanks
Navtej S


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.