postgres
postgres copied to clipboard
chore: bump Wrappers version to 0.4.0
What kind of change does this PR introduce?
- upgrade Wrappers from v0.3.0 to v0.4.0
Additional context
Add any other context or screenshots.
Action Items
- [ ] New extension releases were Checked for any breaking changes
- [ ] Extensions compatibility Checked
- Proceed to extensions compatibility testing, mark as done after everything is completed
- [ ] Backup and Restore Checked
- Proceed to backup testing while extensions are enabled
- After every restore, re-run the tests specified at point 3.1
- Proceed to backup testing while extensions are enabled
Extensions compatibility testing
- Enable every extension
- Check Postgres’ log output for any error messages while doing so
- This might unearth incompatibilities due to unsupported internal functions, missing libraries, or missing permissions
- Check Postgres’ log output for any error messages while doing so
- Disable every extension
- Check Postgres’ log output for any cleanup-related error messages
- Re-enable each extension
- Run basic tests against the features they offer, e.g.:
-
pg_net- execute HTTP requests -
pg_graphql- execute queries and mutations - …to be filled in
-
- Run basic tests against the features they offer, e.g.:
Backup Testing
Follow the testing steps steps for all the following cases:
- Pause on new Postgres version, restore on new Postgres version
- Pause on older Postgres version, restore on new Postgres version
- Run a single-file backup backup, restore the backup
Testing steps
- Generate dummy data
- the ‘Countries’ or ‘Slack clone’ SQL editor snippets are decent datasets to work with, albeit limited
- Save a db stats snapshot file
- Do this by running
supa db-stats gather -p <project_ref>
- Do this by running
- Backup the database, through pausing the project, or otherwise
- Restore the backup, through unpausing the project or cli
- Check the data has been recovered successfully
- Visual checks/navigating through the tables works
- Run
supa db-stats verifyagainst the project and the previously saved file