SigNoz ships with SQLite by default for quick setups. For production and larger deployments, you can configure SigNoz to use a relational database.
Configuration
Set the SIGNOZ_SQLSTORE_PROVIDER environment variable to select the database backend. See configuration options for details.
PostgreSQL
To use PostgreSQL, set the following environment variables on the signoz service:
SIGNOZ_SQLSTORE_PROVIDER: postgres
SIGNOZ_SQLSTORE_POSTGRES_DSN: postgres://signoz:your_password@postgres:5432/signoz?sslmode=disable
- Ensure the specified database already exists and the user has privileges to create and migrate tables.
