Home > Supported and Unsupported Data Types > Azure PostgreSQL
Download this articleAmazon PostgreSQL recovery supports restoring data to the original location or to another location with different settings. Refer to the following table for the supported object types you can protect in Azure PostgreSQL.
| Object Types | Sub Object Types | Backup | Restore |
|---|---|---|---|
| Server -Workload type | Dev / Test | Supported | Unsupported |
| Server -Workload type | Production | Supported | Unsupported |
| Compute Storage | General Purpose | Supported | Unsupported |
| Compute Storage | Memory Optimized | Supported | Unsupported |
| Network | Public Access | Supported | Unsupported |
| Network | Private Access | Supported | Unsupported |
| Zonal resiliency | Disabled | Supported | Unsupported |
| Zonal resiliency | Enabled | Supported | Unsupported |
| Authentication | Postgre SQL and Microsoft Entra Authentication | Supported | Unsupported |
| Security : System-managed key , Customer-managed key | System-managed key | Supported | Unsupported |
| Security : System-managed key , Customer-managed key | Customer-managed key | Supported | Unsupported |
| Object Types | Sub Object Types | Backup | Restore |
|---|---|---|---|
| Database | Character set : UTF9 | Supported | Supported |
| Database | Collation : en_US.utf9 | Supported | Supported |
| Database | Schema type : user | Supported | Supported |