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


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?

asked 2 years ago678 views
1 Answer

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
----- 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
answered 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