Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't find password for postgres user #172

Open
wondersalmon opened this issue Apr 15, 2024 · 6 comments
Open

Can't find password for postgres user #172

wondersalmon opened this issue Apr 15, 2024 · 6 comments

Comments

@wondersalmon
Copy link

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
Copy link
Member

@AndrewChubatiuk Any ideas? 😄

@AndrewChubatiuk
Copy link
Contributor

which version of chart are you trying to upgrade from?

@wondersalmon
Copy link
Author

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
Copy link
Contributor

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
Copy link
Author

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
Copy link
Contributor

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants