Update virtual endpoints in Azure Database for PostgreSQL flexible server

Use the Azure portal:

1. Select the Azure Database for PostgreSQL flexible server for which you want to update its associated virtual endpoints.

2. In the resource menu, under the Settings section, select Replication.

   

3. In the Virtual endpoints section, select the pencil icon. You can update one property of the existing virtual endpoints.

   

4. The only property you can update for an existing pair of virtual endpoints is the Target of the reader virtual endpoint. However, you can only change this property if there's at least one read replica created. Otherwise, it refers to the primary server, just like the Target of writer virtual endpoint property. If the server doesn't have read replicas, you can't change any property, and you must select Cancel.

   

5. If the server has read replicas and you change the value of Target of the reader virtual endpoint, select Save to persist the changes.

   

6. A notification informs you that the virtual endpoints are being updated.

   

7. When the process completes, a notification informs you that the virtual endpoints were successfully updated.

   

Use the az postgres flexible-server virtual-endpoint update command to update the existing virtual endpoints of your Azure PostgreSQL flexible server.

az postgres flexible-server virtual-endpoint update \
  --resource-group <resource_group> \
  --server-name <server> \
  --name <virtual_endpoints_base_name> \
  --endpoint-type ReadWrite
  --members <replica>