Azure Postgres flexible server Creation


1a. We have to create a PostgreSQL Flexible server with minimum configuration B4ms. In the below screenshot, we have to select Subscription, create, or select resource-group, input server name, Region,version16, and workload production, If required select high availability, select PostgreSQL and Microsoft authentication then proceed to the network section.



1b. Select private access, subscription, and Vnet, and create or select a dedicated PostgreSQL subnet, If required we can change the options in security and tags otherwise we can go ahead with default options. then click on review and create.


1c.Once the service is started we have to go to settings-->serverparametes --> extensions then select PGCRYPTO, PLPGSQL, UUID-OSSP and save.




1d. Go to the overview of Postgresqlserver and copy the server name we need to give in PG_HOST.


1e. Go to settings -->databases create a database with names "dataflow",workschema,dataops_genai