Re: [I] [SIP] Ability to connect to postgres with different schema with superset_config [superset]

["Habeeb556 (via GitHub)" <gi...@apache.org>]

Habeeb556 commented on issue #29582:
URL: https://github.com/apache/superset/issues/29582#issuecomment-2226874270

   @justmike1 the error you encountered `sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "ab_user" does not exist` indicates that the tables are created under the `public` schema, causing the application to be unable to locate the `ab_user` table with the new schema, which contains the old login information.
   
   To resolve this, you should connect to your database and move the tables from the `public` schema to the new schema. After that, run the following commands to redeploy the database connection:
   
   ```sh
   export FLASK_APP=superset
   superset db upgrade
   superset init
   ```


-- 
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