[GitHub] [superset] Hongbo-Miao commented on issue #19738: [Helm] sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "ab_permission_view_role" does not exist

[GitBox <gi...@apache.org>]

Hongbo-Miao commented on issue #19738:
URL: https://github.com/apache/superset/issues/19738#issuecomment-1100585069

   Based on the error, I feel maybe Postgres is not ready when Superset tries to initialize (migrate) the database.
   
   So I first deployed my own Postgres, and
   
   First create a file called **my-values.yaml**:
   
   ```
   postgresql:
     enabled: false
   
   supersetNode:
     connections:
       db_host: "my-postgres-service.my-namespace"
       db_port: "5432"
       db_user: admin
       db_pass: passw0rd
       db_name: superset_db
   ```
   
   values.yaml is at https://github.com/apache/superset/blob/master/helm/superset/values.yaml
   
   Then you can run
   
   ```sh
   helm install \
     superset \
     --values=values.yaml \
     --values=my-values.yaml \
     superset/superset
   ```
   
   This will way you can use your own existing Postgres. Now Superset can deploy successfully! Hope it helps future people!


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org