in Azure I created a virtual network. And a subnetwork. And I created a postgreSQL flexible database with credentials:
export PGHOST=dbpostgres-internetsuite2-0-demo.postgres.database.azure.com
export PGUSER=internetsuite2admin
export PGPORT=5432
export PGDATABASE=postgres
export PGPASSWORD="{your-password}"
And I choosed for Private access(vn Integration). But now I want via pgadmin connecten to the Azure postgeSQL database. But for example via powershell. I can not connect to the database. If I try:
ping dbpostgres-internetsuite2-0-demo.postgres.database.azure.com
I get this error:
Ping request could not find host dbpostgres-internetsuite2-0-demo.postgres.database.azure.com. Please check the name and try again
And also I see on the tab connect of the postgresSQL database this warning:
Pre-requisites check
The most common connection methods have one or more of the requirements listed below
Only resources within the virtual network or a peered network to your server will have access.
Server is in Ready state.
So my question is: How to connect to the postgreSQL database with private access with pgadmin localy?