Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Document new pum upgrade functions #208

Open
ponceta opened this issue Feb 20, 2023 · 1 comment
Open

Document new pum upgrade functions #208

ponceta opened this issue Feb 20, 2023 · 1 comment
Assignees

Comments

@ponceta
Copy link
Member

ponceta commented Feb 20, 2023

It is much easier to dump and restore a production database to a test data base and run the upgrade process on it than to run the entire test-and-upgrade procedure.

New way of doing could be :

pum dump -p pg_qgep /var/tmp

pum restore -p pg_qgep_test /var/tmp

pum upgrade -p pg_qgep_test -t qgep_sys.pum_info -d ./delta/ -v int SRID 2056

See actual procedure :

https://qgep.github.io/docs/en/admin-guide/db-update-pum/index.html#

Let the testing approach for CI and debugging only.

@ponceta ponceta self-assigned this Feb 20, 2023
@ponceta ponceta changed the title Document new pum upgrade function Document new pum upgrade functions Feb 20, 2023
@sjib
Copy link
Contributor

sjib commented May 19, 2023

@ponceta Can you update the docs with this or close the issue if not relevant anymore?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants