bcgov / bcgov/backup-container
Database backup validation of DB with PostGIS fails
Open
enhancement
help wanted
- Dominant language
- Shell
- Stars
- 44
- Forks
- 65
- PR merge metrics
- No merged PRs in 30d
Description
We have a PostgreSQL database with PostGIS installed.
The back up validation fails with:
```
[!!ERROR!!] - Backup verification failed; /backups/daily/2020-07-29/invasivesbc-api-postgresql-test-InvasivesBC_2020-07-29_16-50-15.sql.gz
The following issues were encountered during backup verification;
ERROR: could not open extension control file "/opt/rh/rh-postgresql10/root/usr/share/pgsql/extension/postgis.control": No such file or directory
Elapsed time: 0h:0m:40s - Status Code: 3
```
Other psql extensions might suffer from this as well.
Contributor guide
Assessment
This issue has not been assessed yet.