title | description | ms.service | ms.subservice | ms.topic | ms.author | author | ms.date | ms.custom |
---|---|---|---|---|---|---|---|---|
Manage read replicas - Azure PowerShell - Azure Database for PostgreSQL |
Learn how to set up and manage read replicas in Azure Database for PostgreSQL using PowerShell. |
postgresql |
single-server |
how-to |
alkuchar |
AwdotiaRomanowna |
06/24/2022 |
devx-track-azurepowershell |
[!INCLUDE applies-to-postgresql-single-server]
[!INCLUDE azure-database-for-postgresql-single-server-deprecation]
In this article, you learn how to create and manage read replicas in the Azure Database for PostgreSQL service using PowerShell. To learn more about read replicas, see the overview.
You can create and manage read replicas using PowerShell.
To complete this how-to guide, you need:
- The Az PowerShell module installed locally or Azure Cloud Shell in the browser
- An Azure Database for PostgreSQL server
Important
While the Az.PostgreSql PowerShell module is in preview, you must install it separately from the Az
PowerShell module using the following command: Install-Module -Name Az.PostgreSql -AllowPrerelease
.
Once the Az.PostgreSql PowerShell module is generally available, it becomes part of future Az
PowerShell module releases and available natively from within Azure Cloud Shell.
If you choose to use PowerShell locally, connect to your Azure account using the Connect-AzAccount cmdlet.
[!INCLUDE cloud-shell-try-it.md]
Important
The read replica feature is only available for Azure Database for PostgreSQL servers in the General Purpose or Memory Optimized pricing tiers. Ensure the primary server is in one of these pricing tiers.
A read replica server can be created using the following command:
Get-AzPostgreSqlServer -Name mydemoserver -ResourceGroupName myresourcegroup |
New-AzPostgreSqlReplica -Name mydemoreplicaserver -ResourceGroupName myresourcegroup
The New-AzPostgreSqlReplica
command requires the following parameters:
Setting | Example value | Description |
---|---|---|
ResourceGroupName | myresourcegroup | The resource group where the replica server is created. |
Name | mydemoreplicaserver | The name of the new replica server that is created. |
To create a cross region read replica, use the Location parameter. The following example creates a replica in the West US region.
Get-AzPostgreSqlServer -Name mrdemoserver -ResourceGroupName myresourcegroup |
New-AzPostgreSqlReplica -Name mydemoreplicaserver -ResourceGroupName myresourcegroup -Location westus
To learn more about which regions you can create a replica in, visit the read replica concepts article.
By default, read replicas are created with the same server configuration as the primary unless the Sku parameter is specified.
Note
It is recommended that the replica server's configuration should be kept at equal or greater values than the primary to ensure the replica is able to keep up with the primary.
To view all replicas for a given primary server, run the following command:
Get-AzPostgreSQLReplica -ResourceGroupName myresourcegroup -ServerName mydemoserver
The Get-AzPostgreSQLReplica
command requires the following parameters:
Setting | Example value | Description |
---|---|---|
ResourceGroupName | myresourcegroup | The resource group where the replica server will be created to. |
ServerName | mydemoserver | The name or ID of the primary server. |
Stopping a read replica server promotes the read replica to be an independent server. It can be done by running the Update-AzPostgreSqlServer
cmdlet and by setting the ReplicationRole value to None
.
Update-AzPostgreSqlServer -Name mydemoreplicaserver -ResourceGroupName myresourcegroup -ReplicationRole None
Deleting a read replica server can be done by running the Remove-AzPostgreSqlServer
cmdlet.
Remove-AzPostgreSqlServer -Name mydemoreplicaserver -ResourceGroupName myresourcegroup
Important
Deleting a primary server stops replication to all replica servers and deletes the primary server itself. Replica servers become standalone servers that now support both read and writes.
To delete a primary server, you can run the Remove-AzPostgreSqlServer
cmdlet.
Remove-AzPostgreSqlServer -Name mydemoserver -ResourceGroupName myresourcegroup
[!div class="nextstepaction"] Restart Azure Database for PostgreSQL server using PowerShell