Skip to content

Reservoir DDMS PostgreSQL upgrade to v14

saketh somaraju [EPAM] requested to merge az/sa-upgrade-postgress into master

All Submissions:

  • [YES] Have you added an explanation of what your changes do and why you'd like us to include them?
  • [YES] I have updated the documentation accordingly.
  • [YES] My code follows the code style of this project.

Current Behavior or Linked Issues

Related to #324 (closed)

  • Currently reservoir DDMS is using PostgreSQL version 10 and this MR changes the version to PostgreSQL 14.
  • Since airflow is also using terraform postgresql module created separate module for flexible server.
  • Updated reservoir connection string due to breaking changes in connection strings for single and flexible server.
  • Renamed PostgreSQL server name to accommodate both servers at a time for Data migration.
  • Changes are tested when new server is up open-etp-server, open-etp-client in dev secondary environment.

Does this introduce a breaking change?

  • [YES]

  • This change deletes existing PostgreSQL database and creates a new instance of flexible server database, hence downtime is expected.

  • Refer to Azure postgresql migration tool to migrate existing data.

Edited by saketh somaraju [EPAM]

Merge request reports