Database export and load

[LuukS]

Are there any scripts to export and load the GeoHealthCheck data from a PostGIS database?

[LuukS]

I know this possibility: https://docs.geohealthcheck.org/en/latest/admin.html#database

But that is only for the test results. Not for the configuration of these tests.

[justb4]

Can you make this more explicit?

There is

• https://demo.geohealthcheck.org/json all configured resources with Probes.
• https://demo.geohealthcheck.org/api/v1.0/probes-avail/ available resource Probes

What is lacking, and planned for future is a true REST API, a beginning of a spec. has been worked on:
https://github.com/geopython/GeoHealthCheck/wiki/API-Specification

We are looking for funding for this work, as it also will require re-doing of the the current architecture.

[LuukS]

If I request the json I don't get the configuration of the probes. Possible usernames en passwords are missing. What I would like is a way to export all the data from the GeoHealthCheck Postgres database so I can import it into a totally new one and create a totally new GeoHealthCheck instance based on the old data.

Or is it as easy as running the Postgres export and import commands (pg_dump and psql)?

[justb4]

Yes, the Postgres export is a good option for now. This is what is actually used in production to do e.g. nightly or backup/restores on demand. The convenience tool used there is: docker-pgbackup see: https://github.com/justb4/docker-pgbackup and the related Docker image on DockerHub.