Moving from Postgres 9.3 to 9.4

[Dovid Bender]

Hi,

A client is running an older version of Confluence, Jira, crowd etc. with Postgres on RDS 9.3. Because of the CVE's in Confluence we are looking to upgrade. As per https://confluence.atlassian.com/doc/supported-platforms-207488198.html the oldest version supported is Postgres 9.3. I am reviewing amazons docs on upgrading major versions https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion.Process

Some questions:

1. Do Atlassian products have any custom parameter groups?
2. Has anyone simply tried using a snapshot and selecting a newer version of Postgres?
3. Any other thoughts on moving between these versions?

[Stephen Sifers · Accepted solution]

Hello Dovid,

Upgrading Postgres to a new version can always seem daunting and concerning. Outside of the default user used to create and own the database, there is generally no other additional application configuration that is done. When moving a database, it should be as simple the following:

1. Stop Confluence.
2. Take a backup of the PostgreSQL database.
3. Restore the backup of the database to the new PostgreSQL instance.
4. Adjust the Confluence configurations to point to the new instance, also ensure the drivers are correct.
5. Start Confluence up

Always do these types of tests within a staging or developer instance to avoid disruption within Production.

The good news on this is there is a rather detailed KB which covers database migration. This KB covers most of the items you need for a default application install. You may find this article at Migrating to Another Database.

If you do find yourself running into an issue while testing this migration, please do reach back out to use with any errors or logs you’re able to find.

I hope this proves helpful and you’re able to migrate to a new Postgre version soon!

Regards,
Stephen Sifers