Hello! Wanted to deploy locally https://github.com/Netflix/metaflow-service And its necessary to deploy postgres database - test. But i can't find complete script to restore database. Found some migrations here services/migration_service/migration_files, but i suppose it will not be working just like that. Maybe someone can send me full backup database test? And other question. It's available for metaflow-service use another database, like clickhouse for example?

can you give some more details, are you trying to deploy it locally on a Kubernetes cluster, or simply running the docker-compose for development? or something else?

im just trying deploy locally without docker and kubernetes. At least if i read properly manuals.

Ah I see. I do suggest the docker approach for simplicity of getting things up and running, but if you want to proceed trying out the pure python package route, you do need to run the db migrations before the service will work correctly. For production deployments, the entrypoint in the containers is usually configured to be

services.migration_service.run_script.py

which runs the migrations, and then launches the metadata service. An alternative for one-off migrations is to use the

run_goose.py

script. Both of these approaches require db-connection specific environment variables to be present. You can check the

docker-compose.development.yml

for examples (by no means are all of them necessary)

thank you very much!