I got a postgres database in AWS RDS and a deployed NextJS App with Payload on AWS Amplify. When I open the app it seems to load relatively slow and after navigating a bit the images do not load anymore. I found a error log in cloudwatch that explains the issue but I cannot figure out how to avoid this do I also need to setup a proxy for my RDS to pool the connections? I thought this should have been handled out of the box.
[19:48:00] [31mERROR[39m: [36mError: cannot connect to Postgres. Details: remaining connection slots are reserved for roles with privileges of the "rds_reserved" role[39m 2025-11-07T19:48:00.228Z err: { 2025-11-07T19:48:00.228Z "type": "DatabaseError", 2025-11-07T19:48:00.228Z "message": "remaining connection slots are reserved for roles with privileges of the \"rds_reserved\" role",