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. In the resource menu, under the Settings section, select Replication.

   

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

   

4. The two fully qualified domain name aliases (CNAME) records that get created when you create virtual endpoints, have the following 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 which isn't taken already by some other server.

   

5. Target of writer virtual endpoint must always point to the primary server, because that's the only server that is configured to support user initiated write operations. If the server on which you're creating the virtual endpoints don't have any read replica, then Target of reader virtual endpoint also points to the primary server. However, if the server on which you're creating the virtual endpoints has some read replica, by default Target of reader virtual endpoint is pointed to one of the read replicas, and can be changed to point to the primary server or to any other read replica, provided there's more than one.

   

6. Select Create.

   

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

   

8. When the process completes, a notification informs you that the virtual endpoints were successfully created.

   

You can create virtual endpoints for your Azure PostgreSQL flexible server via the az postgres flexible-server virtual-endpoint create command.

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