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?

질문됨 2년 전517회 조회
1개 답변
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
답변함 2년 전
  • 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).

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠