By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

How to upgrade Lightsail Postgres instance? (minor version upgrade)

0

According to the RDS docs, it's possible to manually trigger minor version upgrades for PostgreSQL or even have it upgrade automatically once a new version is approved.

I currently have a database instance in Lightsail, running version 12.8. When creating a new instance, the dropdown offers version 12.11, so I'm assuming I should also be able to upgrade my current instance to 12.11.

Where do I find the manual / auto upgrade options in the Lightsail interface?

Topics
Compute
Tags
Amazon Lightsail
Language
English
AWS-User-6449199
asked 2 years ago1777 views
1 Answer
0

According to the following Lightsail documentation, the specification seems to be that minor database upgrades in Lightsail are performed automatically during maintenance periods. [1]

[1] Changing the preferred maintenance and backup windows for your database in Amazon Lightsail | Lightsail Documentation
https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-changing-preferred-maintenance-and-backup-windows
----- excerpt -----
Minor version upgrades, and other database maintenance tasks, are performed automatically during the preferred maintenance window for your database.
----- excerpt -----

The above documentation does not appear to mention manual upgrades, so we assume that only automatic upgrades are supported.

I hope this helps.

profile picture
mn87
answered 2 years ago
  • AWS-User-6449199
    2 years ago

    Thank you for the pointer to the relevant docs!

    When I list my relational databases via the AWS cli, here is part of the output I get:

    "engine": "postgres",
"engineVersion": "12.8",
"preferredMaintenanceWindow": "mon:22:55-mon:23:25",
"pendingMaintenanceActions": [
  {
    "action": "system-update",
    "description": "New Operating System update is available"
  }
],

    It looks looks like the system knows there is a pending update, but it doesn't install the new version (even though a maintenance window is set).

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content