search

getredash / contrib-helm-chart

Community maintained Redash Helm Chart
Apache License 2.0
163 stars 143 forks source link

Can't find password for postgres user #172

Open wondersalmon opened 7 months ago

wondersalmon commented 7 months ago

Hi all. I have the same problem as #119 I need to migrate a database from a previous redash docker installation to redash installed by this chart, but I don't have a password for the postgres user. I have the password for the redash user but he has no permissions, stalemate. The author of the issue above closed his topic saying that he will solve the problem differently, but I would like to know the password, as it may save me some difficulties in the future.

Chart version 3.0.1.

justinclift commented 7 months ago

@AndrewChubatiuk Any ideas? :smile:

AndrewChubatiuk commented 7 months ago

which version of chart are you trying to upgrade from?

wondersalmon commented 7 months ago

which version of chart are you trying to upgrade from?

I'm trying to install chart from scratch. i have an old installation deployed in docker-compose (redash version 3.0.0), i'm trying to migrate from it to k8s. i'm using chart version 3.0.1

AndrewChubatiuk commented 7 months ago

postgres in docker compose should have either POSTGRES_PASSWORD and POSTGRES_USER env variable set or it should support passwordless login using postgres user

wondersalmon commented 7 months ago

All so, but I tried to do the following:

  1. installed the helmchart from scratch
  2. tried to restore the database from dump and then I got an error because the available user (redash) has no rights, and the user (postgres) has rights but his password is not known to me (and none of the available passwords does not fit, including the blank password, and the "postgre"s password or derivative passwords) I admit that maybe I do everything wrong. In brief - I have a dump of a db made in the docker compose version of redash, I want to deploy it in the redash that was installed by this helm chart
AndrewChubatiuk commented 7 months ago

this old postgresql chart has ability to set admin password https://github.com/bitnami/charts/blob/18f80142d0eb5783d8cbe38010bdc10ec9b3c77d/bitnami/postgresql/values.yaml#L128 in redash you should pass it using postgresql.postgresqlPostgresPassword