Issue
When connecting to Amazon Redshift data source, the following error might occur:'Error occurred while trying to connect: FATAL: too many connections for user "[username]"'
Last Modified Date: 23 May 2019
'Error occurred while trying to connect: FATAL: too many connections for user "[username]"'
Environment
- Tableau Desktop
- Amazon Redshift
Resolution
Amazon Redshift has per-user connection limit. When the limit is reached, subsequent connection attempts will fail. It is recommended to restrict the number of connections per user and per databaseCause
Amazon Redshift limits the number of connections per cluster and per database user.Additional Information
For additional information about this topic, see What are the connection limits in Amazon Redshift, and how do I manage Amazon Redshift connections? in the AWS knowledge center.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials
Related Links
https://aws.amazon.com/premiumsupport/knowledge-center/manage-connection-limits-redshift/