dosubot[bot] commented on issue #35174: URL: https://github.com/apache/superset/issues/35174#issuecomment-3302817851
<!-- Greeting --> Hi @thatguyatgithub! I'm [Dosu](https://go.dosu.dev/dosubot) and Iām helping the superset team. <!-- Answer --> This is a known issue: the default Superset Docker image used by the Helm chart does not include database drivers like psycopg2, which are required to connect to external PostgreSQL databases. You have a few options to resolve this: 1. **Add a bootstrapScript to your Helm values.yaml** to install psycopg2-binary and its system dependencies at container startup. For Superset v5 and newer (which use `uv` as the Python package manager), use: ```yaml bootstrapScript: | #!/bin/bash apt update && apt install -y gcc libpq-dev python3-dev pkg-config uv pip install psycopg2-binary ``` [Reference](https://github.com/apache/superset/discussions/34109) For older versions, replace `uv pip install` with `pip install`. 2. **Use a custom Docker image** that pre-installs psycopg2-binary and any other required drivers. This is recommended for production deployments. Example Dockerfile: ```dockerfile FROM apache/superset:latest RUN pip install --no-cache-dir psycopg2-binary ``` [Reference](https://github.com/apache/superset/issues/33945) 3. **Use the `-dev` tagged Superset image** (e.g., `apache/superset:latest-dev`), which includes common database drivers by default. [Reference](https://github.com/apache/superset/issues/32217) Make sure you also disable the internal PostgreSQL by setting `postgresql.enabled: false` in your values.yaml when using an external DB, and provide your DB connection details under `supersetNode.connections` (do not set `SQLALCHEMY_DATABASE_URI` directly) [Reference](https://github.com/apache/superset/issues/33945). This approach should resolve the `ModuleNotFoundError: No module named 'psycopg2'` in your Helm-based deployment. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/fa259a3f-71c2-48b6-a4e1-d3073eb7c148?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/fa259a3f-71c2-48b6-a4e1-d3073eb7c148?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/fa259a3f-71c2-48b6-a4e1-d3073eb7c148?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/fa259a3f-71c2-48b6-a4e1-d3073eb7c148?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/fa259a3f-71c2-48b6-a4e1-d3073eb7c148?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/fa259a3f-71c2-48b6-a4e1-d3073eb7c148?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/fa259a3f-71c2-48b6-a4e1-d3073eb7c148?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/35174) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
