This page will help you to solve an issue that occurs in AIP Console, while adding a new application whereby it throw's an error while connecting to the database.
Error connecting to database - Can't Connect Database xxxxxxxxxxxx.yyyyyyyy.zzzzzz.rds.amazonaws.com:15131 on CastStorageService
FATAL: remaining connection slots are reserved for non-replication superuser connections.
This error is normally a database configuration issue.
AIP Platform
|
Yes/No
|
CAST AIP 8.3 |
|
AIP Console Version |
Yes/No |
AIP Console 1.8.x or greater |
|
|
This is usually due to some sort of configuration issue, so verify your configuration.
- For default CAST Storage Service installation on Windows, we need to modify the postgresql.conf file which is found here: C:\Program Files\CAST\CASTStorageService3\db_data which is basically: <CSS installation area>\db_data
You need to increase the max_connections configuration setting or (probably better) use connection pooling to route a large number of user requests through a smaller connection pool. Number_Of_Database_Connections
- Restart the PG admin services.
- If you are using AWS RD, you will need to modify the profile or connections to increase it to the max connections. Please get in touch with your AWS team to do the modification.
- On Storage Deployments requirements you can also refer our documentation page: STORAGE.
- If the problem you are facing does not match any case listed in this page, report your problem to CAST Technical Support and provide the below Relevant input for CAST Technical Support to reproduce the issue.
|
Comments