CODEWITHSUNDEEP
postgresqlamazon-web-servicessequelize.jsamazon-rds
Farhan Yaseen
Farhan Yaseen

Reputation: 2707

SequelizeConnectionError Unable to connect to the database

I have RDS db instance of class db.t2.micro with 18 connections active as RDS db instance of class db.t2.micro have maximum 66 connection but i am facing this issue

Unable to connect to the database: { [SequelizeConnectionError: remaining connection slots are reserved for non-replication superuser and rds_superuser connections]

Upvotes: 0

Views: 1049

Answers (1)

Vao Tsun
Vao Tsun

Reputation: 51629

select all conenctions, not just active.

according to docs:

max_connections (integer) Determines the maximum number of concurrent connections to the database server. The default is typically 100 connections, but might be less if your kernel settings will not support it (as determined during initdb). This parameter can only be set at server start.

When running a standby server, you must set this parameter to the same or higher value than on the master server. Otherwise, queries will not be allowed in the standby server.

Upvotes: 0

Related Questions