[Not to be merged] Add PG dump generator script
What
The MR implements design outlined in gitlab-org/quality/quality-engineering/team-tasks#2355 (comment 1777067946)
PG Dump Generator will be used to generate and store PG dumps for upgrade testing. Documentation workflow is added in README.
It can also be used for local debugging of migration errors in GDK which covers point Enable engineers to more easily run this upgrade test locally, without the use of CI
in gitlab-org/quality/quality-engineering/team-tasks#2354 (closed)
Example pipelines:
- If latest PG dump exists - it's not recreated - https://gitlab.com/gitlab-org/quality/pg-dump-generator/-/jobs/6225326175
- If latest PG dump exists - and forced to be rotated - it's created, commited and reported - https://gitlab.com/gitlab-org/quality/pg-dump-generator/-/pipelines/1185259396, MR - !11 (merged), Slack - https://gitlab.slack.com/archives/C06K91RQCDD/p1708531710003139
Why
The change allows to remove PG dump creation job in every MR as well as keep the latest upgrade stop PG file rotated.
More context how the test job works outlined in gitlab-org/quality/quality-engineering/team-tasks#2354 (comment 1775308818) and POC gitlab-org/quality/quality-engineering/team-tasks#1806 (closed)