SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

Hi. We have tested signoz in dev and QA . We are moving to prod. I have a question - the queries which we are building using query builder, where are they backed up ? Is it in the alertmanager's persistent volume or in clickhouse?

Hi <@U05NPBTSAV8> :wave:

Do you mean the queries of alerts? It is stored in SQLiteDB, and the db file is stored in query-service persistent volume.

You could copy the `signoz.db` file from your test environment to production.

That should make the users creds, dashboards and alerts from test environment available.

copy `signoz.db` from your test environment:
```kubectl cp -n platform my-release-signoz-query-service-0:/var/lib/signoz/signoz.db ./signoz.db```

In your production cluster, copy `signoz.db` to your prod environment and restart query-service pod:
```kubectl cp -n platform ./signoz.db my-release-signoz-query-service-0:/var/lib/signoz/signoz.db

kubectl -n platform rollout restart sts/my-release-signoz-query-service```