lboross-ia commented on issue #24469: URL: https://github.com/apache/superset/issues/24469#issuecomment-2283324370
I had issues with this as well. It seems like the superset db upgrade is broken or incomplete for Postgres. If you compare the SQLite Meta database to the Postgres after a fresh db upgrade and superset fab create-admin, you will notice ab_role, ab_user_role, ab_view_menu, ab_permission_view, ab_permission_view_role etc are missing rows. My hack for this was to open the SQLite database in dbeaver and export these tables to my postgres meta database. You will need to work around the primary key ID's and sequence numbers but its possible to make it work. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
