supavisor
supavisor copied to clipboard
feat: use simple_connection for auth_query
The PID of the Postgrex connection can be lost when ClientHandler terminates in the middle of getting secrets via auth_query. As a result, we may get zombie connections, which can consume all allowed connections to the tenant's database. With this PR, auth_query will be done with SimpleConnection, where the process crashes automatically if the caller (ClientHandler) goes down.