This option provides backup data availability across availability zones and restricts replication of data to within a country/region to meet data residency requirements. When the backups are stored in zone-redundant backup storage, multiple copies are not only stored within the availability zone in which your server is hosted, but also replicated to another availability zone in the same region. Zone-redundant backup storage: This option is automatically chosen for regions that support availability zones. Backup redundancy helps ensure that your database meets its availability and durability targets, even if failures happen. These events can include transient hardware failures, network or power outages, and natural disasters. Backup redundancy optionsįlexible Server stores multiple copies of your backups to help protect your data from planned and unplanned events. In general, the delay (recovery point objective, or RPO) can be up to 15 minutes. Transaction log backups happen at varied frequencies, depending on the workload and when the WAL file is filled and ready to be archived. Snapshot backups are currently taken once daily. The first snapshot backup is scheduled immediately after a server is created. Backup frequencyīackups on flexible servers are snapshot based. For that purpose, you can use the PostgreSQL tools pg_dump and pg_restore/psql.
These backup files can't be exported or used to create servers outside Azure Database for PostgreSQL - Flexible Server. All backups are encrypted through AES 256-bit encryption for data stored at rest. The default backup retention period is 7 days, but you can extend the period to a maximum of 35 days. You can use these backups to restore a server to any point in time within your configured backup retention period. The server also backs up transaction logs when the write-ahead log (WAL) file is ready to be archived. Backup overviewįlexible Server takes snapshot backups of data files and stores them securely in zone-redundant storage or locally redundant storage, depending on the region. The overall time to restore and recovery typically depends on the size of data and the amount of recovery to be performed. You can then do a point-in-time recovery (PITR) within a retention period that you specify. They help protect data from accidental corruption or deletion.Īzure Database for PostgreSQL - Flexible Server automatically performs regular backups of your server. Azure Database for PostgreSQL - Flexible Serverīackups form an essential part of any business continuity strategy.
0 kommentar(er)
