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

Question

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!

Answer 1

@崔磊

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