[Question][PostgreSQL] How to Configure PostgreSQL Instead of MySQL in DevLake Helm Chart?

[itayb-legit]

In the DevLake architecture documentation, it states:

Database: The database stores both DevLake’s metadata and user data collected by data pipelines. DevLake supports MySQL and PostgreSQL as of v0.11.

However, when reviewing the Helm chart values.yaml, I noticed the following configuration:

option:
  # database type, supported: [mysql]

The comment only mentions support for MySQL. Could you provide guidance on how to configure PostgreSQL as the database for DevLake when deploying with the Helm chart? Are there any specific changes required in the Helm chart or additional steps to enable PostgreSQL support?

Thank you!

[dosubot]

Hey @itayb-legit! I'm here to help you with your DevLake Helm chart question. I can provide guidance and assistance while you wait for a human maintainer.

A similar issue was previously discussed and resolved. The solution involved a pull request that added support for PostgreSQL in the Helm chart. You can find the details of the fix in this pull request: apache/incubator-devlake-helm-chart#45 ^[1]. This should provide the necessary changes to configure PostgreSQL as the database when deploying DevLake with the Helm chart.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[kostas-petrakis]

PostgreSQL is not fully supported yet, there are still issues that need to be fixed (example issue).
If you are also willing to support the project and contribute that would be great as PostgreSQL support is a pain point for others as well.