Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement database schema backup #765

Open
FedericoCeratto opened this issue Nov 2, 2023 · 1 comment
Open

Implement database schema backup #765

FedericoCeratto opened this issue Nov 2, 2023 · 1 comment
Assignees
Labels
bug Something isn't working priority/low

Comments

@FedericoCeratto
Copy link
Contributor

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

@FedericoCeratto FedericoCeratto changed the title Implement Database schema backup Implement database schema backup Nov 10, 2023
@hellais hellais self-assigned this Mar 6, 2024
@hellais hellais added bug Something isn't working priority/low labels Mar 15, 2024
@hellais
Copy link
Member

hellais commented Mar 15, 2024

We are moving towards using postgresql for everything that cannot be rebuilt from source, see: #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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working priority/low
Projects
None yet
Development

No branches or pull requests

2 participants