Update virtual endpoints

Using 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, which lets you update one property of the existing virtual endpoints.

   

4. The only property you can update of an existing pair of virtual endpoints is the Target of the reader virtual endpoint. However, it can only be changed if there's at least one read replica created. Otherwise, it will refer to the primary server, just like the Target of writer virtual endpoint property does. If the server doesn't have read replicas, you cannot 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.

   

You can update the existing virtual endpoints of your Azure PostgreSQL flexible server via the az postgres flexible-server virtual-endpoint update command.

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