[bitnami/postgresql] helm dependency

[sallydeh]

Name and Version

postgresql-12.1.9

What architecture are you using?

amd64

What steps will reproduce the bug?

I have added this to my helm chart dependencies:

 - name: postgresql
    version: 12.1.9
    repository: "https://charts.bitnami.com/bitnami"
    tags:
      - database

and I configured valuse.yaml of my application to override the username and password of the dependent helm chart as follows:

postgresql:
  name: postgres
  databasePort: 5432
  fullnameOverride: postgres
  auth:
    username: "testuser"
    password: "testpass"

  rbac:
    create: true

What do you see instead?

after installing my application using Helm, the log of postgres pod is as follows:

 FATAL:  password authentication failed for user "testuser"
 DETAIL:  Role "testuser" does not exist.

Do you know how to enable my application to use Bitnami Postgres as a dependency by setting user and password?

[javsalgar]

Hi,

Could you share the logs of the PostgreSQL pods?

[sallydeh]

Hi @javsalgar ,

thanks for answering. here is the log

2024-09-12 13:45:31.496 GMT [105] FATAL:  password authentication failed for user "root"
2024-09-12 13:45:31.496 GMT [105] DETAIL:  Role "root" does not exist.
    Connection matched pg_hba.conf line 1: "host     all             all             0.0.0.0/0               md5"

i wonder where do i need to define role in my application that uses postgres as dependency?

[javsalgar]

Hi,

Where does that reference to user root come from? Is there any client accessing to user root?

[github-actions[bot]]

This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.

[github-actions[bot]]

Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.