Verify Troubles with PostGIS

DerekRoberts commented 5 years ago

sh-4.2$ ./backup.sh -v test -f also_a_test

Verifying backup ...

Settings:
- Database: test
- Backup file: /backups/daily/2019-04-03/gwells-pgsql-staging-gwells_2019-04-03_11-00-17.sql.gz

Would you like to continue?  Press Ctrl-C to exit, or any other key to continue ...

waiting for server to start.........
Restoring from backup ...
Restoring to 127.0.0.1:5432 ...
DROP DATABASE "test";
DROP DATABASE

CREATE DATABASE "test";
CREATE DATABASE

GRANT ALL ON DATABASE "test" TO "user24W";
GRANT

Restoring from backup ...
SET
SET
SET
SET
SET
SET
SET
SET
CREATE SCHEMA
ALTER SCHEMA
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
ERROR:  could not open extension control file "/opt/rh/rh-postgresql96/root/usr/share/pgsql/extension/postgis.control": No such file or directory
Restore complete - Elapsed time: 0h:0m:1s

waiting for server to shut down.... done
server stopped
Cleaning up ...

[!!ERROR!!] - Backup verification failed; /backups/daily/2019-04-03/gwells-pgsql-staging-gwells_2019-04-03_11-00-17.sql.gz

Elapsed time: 0h:0m:12s - Status Code: 3

WadeBarnes commented 5 years ago

@DerekRoberts, What's the name of the base image you are using?

DerekRoberts commented 5 years ago

@WadeBarnes It's one that was created for GWells a while back by the devops team. Sounds like we might have to replace it.

docker-registry.default.svc:5000/moe-gwells-tools/postgresql-oracle-fdw:9.6-1

https://github.com/bcgov/openshift-postgresql-oracle_fdw

WadeBarnes commented 5 years ago

@DerekRoberts, I don't have access to that project to pull a copy of the image for testing.

DerekRoberts commented 5 years ago

@WadeBarnes How about now? View and image-puller rights temporarily granted.

WadeBarnes commented 5 years ago

We determined the image was missing the required plug-ins. So it's simply a matter of updating the image, or switching to a base image that contains the plug-ins.

BCDevOps / backup-container

Verify Troubles with PostGIS #22