As part of a stories in the previous sprint we identified Products that were dependant on Postgres v9.3 for the purposed of upgrading them to a supported version. A list of products was identified (#85) and Product Teams were contacted (#92) to tell them about the need to upgrade and to ask what support might be required.
The Parliamentary Questions (PQ) Team confirmed that they would need assistance from Cloud Platform to carry out the upgrade on their behalf.
Proposed user journey and Approach
Depends on #153 being completed.
Agree with PQ when Staging can be upgraded
Carry out upgrade from 9.3 to 9.6 using AWS Postgres upgrade console
PQ Team test PQ Staging instance
PQ Team sign-off on upgrade success and agree any monitoring period
If unsuccessful implement rollback procedure as be #148
PQ and CP investigate any errors and agree to repeat upgrade if required
Questions / Assumptions
Depends on #153
PQ Team have identified a contact to work with us (confirmed as Daniel Penny in Tactical Products)
PQ Team have confirmed that Dev, Staging and Production are using the same version of Postgres (confirmed by Andy Robb)
PQ application is compatible with Postgres 9.6 (confirmed by Andy Robb)
It is possible that we need to investigate and carry out any remedial action to ensure that an old version of Postgres is not deployed in the event of a complete rebuild. This work will be carried out under a separate story.
Definition of done
[x] #153 completed
[x] agreement for PQ Team to upgrade Staging instance of Postgres
Background
As part of a stories in the previous sprint we identified Products that were dependant on Postgres v9.3 for the purposed of upgrading them to a supported version. A list of products was identified (#85) and Product Teams were contacted (#92) to tell them about the need to upgrade and to ask what support might be required.
The Parliamentary Questions (PQ) Team confirmed that they would need assistance from Cloud Platform to carry out the upgrade on their behalf.
Proposed user journey and Approach
Questions / Assumptions
Definition of done
Reference
How to write good user stories List of products using Postgres 9.3