# Azure Database for PostgreSQL URL: https://antifailure.dev/docs/providers/azurepg Branching a Flexible Server with a point in time restore, why this provider does not claim copy on write, and the three things Azure does not carry across a restore. --- A branch here is a **point in time restore** of an Azure Database for PostgreSQL Flexible Server. It needs no dump and no reload, and it produces a server carrying the golden's rows without anything reading them over a connection. It is the only mechanism Azure offers that does. ## This provider does not claim copy on write, and that is deliberate The Aurora and Cloud SQL providers report copy on write branching. **This one reports that it does not.** Microsoft documents a restore as creating a **new server**, and describes the restored server as an independent copy: the physical files are restored from the snapshot backups to the new server's data location, and a recovery process then replays write ahead log files to bring it to a consistent state. Nothing in Microsoft's documentation says the restored server shares storage with its source. The temptation to claim otherwise is real, because Microsoft also writes that "the data restore operation from a snapshot doesn't depend on the size of data", which reads exactly like a copy on write sentence. The same paragraph continues that the recovery timing "might vary, depending on the previous backup of the requested date and time and the number of logs to process", and gives the overall recovery as **a few minutes up to a few hours**. So one half of the operation is flat in the size of the data and the other half is not flat in anything you control. Quoting the first half and declaring copy on write would be quoting the fast part of a number whose slow part is the one you wait through. Declaring it false is not a way of dodging the question. The conformance suite requires the **opposite** proof of a provider that declares false: that branch time does grow with the size of the database. The honest declaration is the one that leaves the behaviour testable. ## Three things Azure does not carry across a restore Each of these is an outage or an exposure if a provider assumes otherwise, and each is handled here. **Firewall rules are not copied.** Microsoft lists applying them as a post restore task. A branch created and left alone is a server nobody can connect to, and the failure arrives as a connection timeout that mentions no firewall at all. For a public source, this provider requires an explicit range and creates the rule. A private source retains its delegated subnet and private DNS zone, with public network access disabled and no public firewall rule. **The administrator credential is copied.** A restored server keeps the source's administrator login, so without an explicit reset every preview environment would be reachable with production's database credential. A distinct password is derived for every restore. **Public and private access cannot be crossed.** A server on a virtual network restores only to a virtual network, and one on public access only to public access. Restores preserve the source's access model. A private source without its DNS zone is refused before provisioning. The engine must be able to reach that private network to mask, verify and use the restored database. Server parameters are not copied either. A source tuned for production comes back at the defaults, which is worth knowing and is not something this provider tries to fix for you. ## What it looks like ```yaml database: provider: azurepg project: acme-production api_key_env: AF_AZUREPG_BRANCH_KEY ``` `project` is the **flexible server** goldens are restored from. The fully qualified domain name is accepted too and the server name is taken from it. | Variable | What it is | | ---: | --- | | `AF_AZUREPG_SUBSCRIPTION` | The subscription holding the servers | | `AF_AZUREPG_RESOURCE_GROUP` | The resource group the servers live in | | `AF_AZUREPG_BRANCH_KEY` | The key every restore's administrator password is derived from | | `AF_AZUREPG_ALLOW_CIDR` | The range the created firewall rule admits. Required for public sources | | `AF_AZUREPG_DATABASE` | The application database. Required when several application databases exist | | `AF_AZUREPG_LOCATION` | The region. A restore lands in its source's region | | `AF_AZUREPG_TLS_MODE` | The `sslmode` of the connection strings. Defaults to `verify-full`, which checks the server certificate and hostname | Remote connections require `verify-full`. The provider supplies Microsoft's published Azure root certificates through an explicit certificate file, so clients that do not use the operating system trust store still verify the server. The engine installs that public bundle inside service containers. Weaker modes are restricted to loopback API fixtures. `AF_AZUREPG_ALLOW_CIDR` has no default on purpose. A default of `0.0.0.0/0` would make every branch work immediately and would open a copy of production to the whole internet. Resource Manager calls authenticate with the engine's Azure credential chain: `AZURE_TENANT_ID`, `AZURE_CLIENT_ID` and `AZURE_CLIENT_SECRET`. The identity needs permission to read and restore servers, update their credentials and metadata, and delete the resources this provider owns. Scope that permission to the dedicated resource group. These are control plane credentials, separate from the database administrator password derived from the branch key. With no client secret, the existing Azure token source uses the host's managed identity. Set `AZURE_CLIENT_ID` to select a user-assigned identity when needed. Collection reads follow Azure pagination. An invalid row is logged and skipped without discarding valid rows, and continuation URLs cannot send the identity to another origin. Accepted restores that are cancelled are cleaned up with a fresh context. ## Deleting a server deletes its backups Microsoft states this plainly, and it is why every destructive path here reads an `antifailure` resource tag before acting rather than trusting a name. A customer whose own server happens to be called `af-b-something` must not lose it to our garbage collection, and on Azure there is nothing to restore from afterwards. ## What is not here **Reset.** A restore creates a new server rather than returning an existing one to an earlier state, which Microsoft states directly: a restore "always creates a new database server with the name that you provide. It doesn't overwrite the existing database server." There is no operation matching the capability, so the conformance suite skips the behaviour by name. **Microsoft Entra database authentication.** Flexible Server supports it, it would be the better credential, and it is not implemented. ## What has been proved, and what has not The provider's own suite drives a fake Resource Manager with a real Postgres behind it, and the fake models all three of the things Azure does not carry across a restore, so a provider that forgot one fails there rather than in your subscription. The default suite does not assert a real service, so service owned conformance verdicts report as unproven. The separate opt-in private Azure test restores a synthetic source, masks and verifies its row, branches it, checks that the source stayed unchanged, and deletes the branch and golden. A successful live run is required before claiming that path has been proved on Azure. That run has completed once, on 2026-09-13, from a container inside a private network against a real flexible server in `centralus`, at commit `8a639dcc46f2`. The golden was restored, masked and verified over a `verify-full` connection that accepted Microsoft's certificate in 420.3 seconds. The branch took 518.3 seconds, including the wait for the golden's first backup, a write on it did not reach the source, a login copied from the source was refused, the goldens were listed, and the branch and golden were deleted to an empty inventory. Two earlier runs failed, and each found a defect that is now fixed. The first branch restore asked for a point in time before the golden's first backup existed, which Azure answers with `InternalServerError`. The second listed the branch as a second golden, because a restore carries the source server's tags.