Sometimes we might need to dump data from production DB and upload them on staging DB.
We came across an issue in DSS where the staging database was empty. We had to use a dump file from production and load the data on staging.
We came across various permission issues and did extra work restoring a dump using restic then pulling the .sql locally , changing the dss_production instances in the sql file, scp the file on lib-postgres-staging and coming across various permissions issues using different pg_restore commands.
Acceptance criteria
[ ] Document the steps and the commands that someone needs to run
Why is this documentation needed?
Sometimes we might need to dump data from production DB and upload them on staging DB. We came across an issue in DSS where the staging database was empty. We had to use a dump file from production and load the data on staging. We came across various permission issues and did extra work restoring a dump using restic then pulling the .sql locally , changing the dss_production instances in the sql file, scp the file on lib-postgres-staging and coming across various permissions issues using different pg_restore commands.
Acceptance criteria
Implementation notes, if any
See notes in https://github.com/pulibrary/DSS/issues/418#issuecomment-2065214180
See documentation for bibdata