search

SEED-platform / seed

Standard Energy Efficiency Data (SEED) Platform™ is a web-based application that helps organizations easily manage data on the energy performance of large groups of buildings.
Other
106 stars 55 forks source link

Docker upgrade database #4650

Closed dhaley closed 1 month ago

dhaley commented 2 months ago

Any background context you want to provide?

The script ./docker/postgres_upgrade.sh will properly upgrade a database from pg12.7-(2.3.0) to pg14.11-(2.14.2). It works in conjunction with the "docker-compose.pgupgrade.yml" docker-compose file to temporarily run Timescale Postgres 13 and 14 images.

What's this PR do?

How should this be manually tested?

./docker/postgres_upgrade.sh --source-pg-conv-version 13 --source-ts-conv-version 2.11.2 --target-pg-test-version 14 --target-ts-test-version 2.11.0

What are the relevant tickets?

Screenshots (if appropriate)

github-actions[bot] commented 2 months ago

Label error. Requires at least 1 of: Feature, Bug, Enhancement, Maintenance, Documentation, Performance, Do not publish. Found:

github-actions[bot] commented 2 months ago

Label error. Requires at least 1 of: Feature, Bug, Enhancement, Maintenance, Documentation, Performance, Do not publish. Found:

github-actions[bot] commented 2 months ago

Label error. Requires at least 1 of: Feature, Bug, Enhancement, Maintenance, Documentation, Performance, Do not publish. Found:

axelstudios commented 2 months ago

Might also be worth using the --exit-on-error flag with pg_restore

dhaley commented 2 months ago

Might also be worth using the --exit-on-error flag with pg_restore

Will do.

github-actions[bot] commented 2 months ago

Label error. Requires at least 1 of: Feature, Bug, Enhancement, Maintenance, Documentation, Performance, Do not publish. Found:

github-actions[bot] commented 2 months ago

Label error. Requires at least 1 of: Feature, Bug, Enhancement, Maintenance, Documentation, Performance, Do not publish. Found:

github-actions[bot] commented 2 months ago

Label error. Requires at least 1 of: Feature, Bug, Enhancement, Maintenance, Documentation, Performance, Do not publish. Found: