Verify that your environment meets the system requirements for PostgreSQL data on an Azure application.
Software Requirements
-
Packages required on access nodes:
-
Virtual Server Agent
-
PostgreSQL Agent
-
-
Access nodes that you run backup and restore operations on must have one of the following operating systems:
|
Operating system |
Processor architecture |
|---|---|
|
Amazon Linux 2023 AMI |
|
|
Amazon Linux 2 AMI (HVM) - Kernel 5.10, SSD Volume Type |
|
|
CentOS 7.x, 8.x |
|
|
Oracle Linux Enterprise 9.x, 8.x, 7.x |
|
|
Red Hat Enterprise Linux 9.x, 8.x, 7.x |
|
|
Rocky Linux 9.x, 8.x |
|
|
Windows 2022, 2019, 2016, 2012 |
|
Note
-
If you have network configuration enabled on the access nodes, before you deploy a Windows or a Linux proxy, configure a firewall on the cloud proxy and on-premises.
-
Amazon Linux 2023 on 64-bit (Arm) and 64-bit (x86) are supported for PostgreSQL 15.x only. For more information, go to AWS documentation on supported packages.
Azure Cloud
Verify that the following ports are open:
-
Inbound rules for PostgreSQL instance
- 5432 to allow connections from backup gateway
-
Outbound rules on backup gateway
-
443 to management.azure.com
-
5432 for backup gateway to connect to PostgreSQL endpoints
-
User Account Requirements
Verify that the PostgreSQL instance has a user account with sufficient privileges to perform pg_dump and pg_restore for databases to be backed up. The following table illustrates the necessary privileges the user account should have to perform backup and restore operations:
| Operations | Privileges PostgreSQL User Should Have |
|---|---|
| Backup | CREATEDB, CREATEROLE |
| Restore | CREATEDB, CREATEROLE, INHERIT, LOGIN |
CONNECTION LIMIT, if set, should at least have a value of 2.
Important
The user should be the member of azure_pg_admin role.
Supported PostgreSQL Versions
From PostgreSQL version 12.x to version 17.x
SSL and TLS Support
The supported TLS versions to create Azure SSL encrypted PostgreSQL instances are TLS 1.0, 1.1 and 1.2.