search

ooni / backend

Everything related to OONI backend infrastructure: ooni/api, ooni/pipeline, ooni/sysadmin, collector, bouncers and test-helpers
BSD 3-Clause "New" or "Revised" License
48 stars 28 forks source link

Implement database schema backup #765

Open FedericoCeratto opened 8 months ago

FedericoCeratto commented 8 months ago

Improve https://github.com/ooni/backend/blob/master/analysis/ooni_db_backup.py backing up "CREATE TABLE ..." for all tables.

hellais commented 3 months ago

We are moving towards using postgresql for everything that cannot be rebuilt from source, see: https://github.com/ooni/backend/issues/807. When we do that this will no longer be needed since postgresql is a managed instance that's already backed up automatically.

For clickhouse we should ensure that the DB schema creation is handled as part of the relevant service component in the code.