Create virtual endpoints

Using the Azure portal:

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

2. Select the Azure Database for PostgreSQL flexible server for which you want to create virtual endpoints.

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

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

   

5. In the Virtual endpoints section, select Create virtual endpoints.

   

6. The two fully qualified domain name aliases (CNAME) records that get created when you create virtual endpoints follow this pattern: <virtual-endpoints-base-name>.writer.postgres.database.azure.com and <virtual-endpoints-base-name>.reader.postgres.database.azure.com. In the Create virtual endpoints dialog, in the Virtual endpoints base name, enter a meaningful name that isn't already taken by another server.

7. The two fully qualified domain name aliases (CNAME) records that get created when you create virtual endpoints follow this pattern: <virtual-endpoints-base-name>.writer.postgres.database.azure.com and <virtual-endpoints-base-name>.reader.postgres.database.azure.com. In the Create virtual endpoints dialog, in the Virtual endpoints base name, enter a meaningful name that isn't already taken by another server.

   

8. The Target of writer virtual endpoint always points to the primary server, because it's the only server that supports user-initiated write operations. If the server where you're creating the virtual endpoints doesn't have any read replica, the Target of reader virtual endpoint also points to the primary server. However, if the server where you're creating the virtual endpoints has some read replicas, Target of reader virtual endpoint points to one of the read replicas by default. You can change it to point to the primary server or to any other read replica, as long as there's more than one.

9. The Target of writer virtual endpoint always points to the primary server, because it's the only server that supports user-initiated write operations. If the server where you're creating the virtual endpoints doesn't have any read replica, the Target of reader virtual endpoint also points to the primary server. However, if the server where you're creating the virtual endpoints has some read replicas, Target of reader virtual endpoint points to one of the read replicas by default. You can change it to point to the primary server or to any other read replica, as long as there's more than one.

   

10. Select Create.

11. Select Create.

    

12. A notification informs you that the virtual endpoints are being created.

13. A notification informs you that the virtual endpoints are being created.

14. When the process finishes, a notification informs you that the virtual endpoints were successfully created.

15. When the process finishes, a notification informs you that the virtual endpoints were successfully created.

    

Use the az postgres flexible-server virtual-endpoint create command to create virtual endpoints for your server.

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