jiajie-chen commented on issue #40532: URL: https://github.com/apache/airflow/issues/40532#issuecomment-2237061063
FWIW, it seems like replacing the `GRANT ... public` with the following allowed using a different schema: ```sql -- Make sure you're logged in as the `airflow` user to the `airflow` database CREATE SCHEMA AUTHORIZATION airflow; GRANT ALL ON SCHEMA airflow TO airflow; ALTER USER airflow SET search_path = airflow; -- If you're on Postgres <15.7, also remove permissions to `public` ``` This was tested with the Airflow `apache/airflow:2.9.2-python3.9` Docker image, running `airflow db migrate` against Postgres `15.7`. All tables were created in the `airflow` schema. -- 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]
