Supported way to pause Supabase Auth during PostgreSQL maintenance without stopping the database?
Context
We use a managed Supabase Pro project as an isolated evidence lab. We need to perform a one-time transactional upgrade of an application-owned PostgreSQL schema ("auth_evidence_ops"), while keeping PostgreSQL and the connection pooler available.
Supabase Auth has an HTTP Send Email Hook connected to an external receiver that persists durable receipts using an independent database connection.
What we need
A verifiable maintenance procedure to prevent new Auth operations capable of producing emails or Send Email Hook callbacks, including administrative operations and requests from existing sessions.
We also need to account for in-flight requests, retries, and delayed effects before starting the database upgrade.
What we've investigated
Using an isolated local environment with GoTrue v2.195.0, PostgreSQL 17.11, and synthetic data, we evaluated:
None demonstrated complete Auth quiescence.
We also reproduced a case where Auth returned HTTP 500 without retaining a new Auth user, while the external receiver had already committed its receipt. Hook timeouts did not guarantee cancellation of remote work.
These results are local, not evidence of hosted behavior.
We reviewed "Supabase discussion #29370" (https://github.com/orgs/supabase/discussions/29370), but its no-op Hook approach does not appear to provide complete Auth quiescence.
Questions
No hosted configuration changes or migrations have been performed.
We would appreciate guidance from Supabase maintainers or community members familiar with managed Auth internals and maintenance procedures.
The user is seeking a method to pause Supabase Auth operations during a PostgreSQL schema upgrade without stopping the database. They need to prevent new Auth operations that could trigger emails or HTTP callbacks. Despite testing various methods locally, they have not achieved complete Auth quiescence and are asking for guidance on a supported procedure for hosted environments.