System Requirements for Amazon RDS for PostgreSQL

To back up and restore Amazon RDS for PostgreSQL, verify that your environment meets the system requirements.

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 2 AMI (HVM) - Kernel 5.10, SSD Volume Type

  • 64-bit (Arm) (recommended)

  • 64-bit (x86)

CentOS 8.x, 7.x

  • x64

  • Compatible processors

Oracle Linux Enterprise 8.x, 7.x

  • x64

  • Compatible processors

Red Hat Enterprise Linux 8.x, 7.x

  • x64

  • Compatible processors

Windows 2019, 2016, 2012

  • x64

  • Compatible processors

Supported PostgreSQL Versions

From PostgreSQL version 9.6 to version 13.x

User Account Requirements

For DumpBasedBackupSet, verify that the PostgreSQL agent has a user account with sufficient privileges to perform the following:

  • Perform backup and restore operations

  • Access the PostgreSQL database objects as part of the subclient content

    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.

    Initially, the user account credentials are provided during the instance configuration after the installation of the agent. You can change the user account at the instance level.

SSL and TLS Support

The supported TLS versions to create Amazon SSL encrypted PostgreSQL instances are TLS 1.0, 1.1 and 1.2.

Loading...