Since I migrated my db source from Google Sheets to Keystone (PostgreSQL), all that I earned from that are problems. The error code is the following: “Error: Data table ‘equipment’ is not accessible due to: 53300: remaining connection slots are reserved for roles with privileges of the "pg_use_reserved_connections" role”. My pricing plan is Core. Mi question is why this happens all the time? Has anyone been able to get applications working with this data source?
For RDBMS connection you would need an Enterprise plan.
Please check the pricing plans page for allowed data sources with each plan.
3 Likes
That’s a rate limit error from your postgres database, not from AppSheet.
Your database either does not support sufficient connections for your appsheet app/userbase, or its holding open connections (sometimes an issue if your provider is using connection pooling).
5 Likes