Problems with RDS Proxy

[osbornk]

We use RDS Proxy for PostgreSQL. We currently have Kratos configured with the standard DSN:

postgres://user:[email protected]:5432/kratos

This works fine. I can use the /sessions/whoami endpoint on a 24 hour token. But after 10 minutes or so of inactivity I will get a 401 from that endpoint for 1-2 requests. And then I get the correct session response again.

Looking at the logs, it looks like Kratos is having a SQL connection error. It very much looks like a stale connection issue. I do know that RDS Proxy kills inactive connections after some time.

Is there better query parameters to use on the DSN URL? The application should be able to handle this since it is a common setup.