Upgrading a PostgreSQL DB snapshot - Amazon Relational Database Service

Upgrading a PostgreSQL DB snapshot

With Amazon RDS, you can create a storage volume DB snapshot of your PostgreSQL DB instance. When you create a DB snapshot, the snapshot is based on the engine version used by your Amazon RDS instance. In addition to upgrading the DB engine version of your DB instance, you can also upgrade the engine version for your DB snapshots.

After restoring a DB snapshot upgraded to a new engine version, make sure to test that the upgrade was successful. For more information about a major version upgrade, see Upgrading the PostgreSQL DB engine for Amazon RDS. To learn how to restore a DB snapshot, see Restoring from a DB snapshot.

You can upgrade manual DB snapshots that are either encrypted or not encrypted.

For the list of engine versions that are available for upgrading a DB snapshot, see Upgrading the PostgreSQL DB engine for Amazon RDS.

Note
  • The DB snapshot must be from the same AWS Region as the account.

  • You can't upgrade DB snapshots that are copied within region, copied across regions, or shared across accounts.

  • You can't upgrade automated DB snapshots that are created during the automated backup process.

To upgrade a DB snapshot

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, choose Snapshots.

  3. Choose the snapshot that you want to upgrade.

  4. For Actions, choose Upgrade snapshot. The Upgrade snapshot page appears.

  5. Choose the New engine version to upgrade to.

  6. Choose Save changes to upgrade the snapshot.

    During the upgrade process, all snapshot actions are disabled for this DB snapshot. Also, the DB snapshot status changes from available to upgrading, and then changes to active upon completion. If the DB snapshot can't be upgraded because of snapshot corruption issues, the status changes to unavailable. You can't recover the snapshot from this state.

    Note

    If the DB snapshot upgrade fails, the snapshot is rolled back to the original state with the original version.

To upgrade a DB snapshot to a new database engine version, use the AWS CLI modify-db-snapshot command.

Parameters

  • --db-snapshot-identifier – The identifier of the DB snapshot to upgrade. The identifier must be a unique Amazon Resource Name (ARN). For more information, see Working with Amazon Resource Names (ARNs) in Amazon RDS.

  • --engine-version – The engine version to upgrade the DB snapshot to.

Example

For Linux, macOS, or Unix:

aws rds modify-db-snapshot \ --db-snapshot-identifier my_db_snapshot \ --engine-version new_version

For Windows:

aws rds modify-db-snapshot ^ --db-snapshot-identifier my_db_snapshot ^ --engine-version new_version

To upgrade a DB snapshot to a new database engine version, call the Amazon RDS API ModifyDBSnapshot operation.

  • DBSnapshotIdentifier – The identifier of the DB snapshot to upgrade. The identifier must be a unique Amazon Resource Name (ARN). For more information, see Working with Amazon Resource Names (ARNs) in Amazon RDS.

  • EngineVersion – The engine version to upgrade the DB snapshot to.

Example

https://rds.us-west-2.amazonaws.com/ ?Action=ModifyDBSnapshot &DBSnapshotIdentifier=mydbsnapshot &EngineVersion=newversion &SignatureVersion=4 &Version=2014-10-31 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20161222/us-west-1/rds/aws4_request &X-Amz-Date=20161222T233051Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=8052a76dfb18469393c5f0182cdab0ebc224a9c7c5c949155376c1c250fc7ec3