Your Location is: Home > Postgresql

Cannot modify a default parameter group for remaining connection slots on Amazon RDS

From: Syria View: 4275 user1469734 

Question

I keep getting:

SQLSTATE[08006] [7] FATAL: remaining connection slots are reserved for non-replication superuser connections (SQL: select * from "sheeps" where "name" = foobar limit 1)

So I thought of modifying the value in the paramaeter group (max_connections default on 270)

But when I change the max_connections to a higher value, I get:

"Error saving: Cannot modify a default parameter group. (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterValue; Request ID: b5179a68-xxxx-44a8-b396-xxx; Proxy: null)"

I have the max limit Laravel Vapor offers: 3008 mb.

Best answer

You can't modify the default parameter group in AWS RDS.

You need to create a custom parameter group, set max_connections in that group, and then attach it to your PostgreSQL RDS instance. You'll then need to restart your PostgreSQL RDS instance for the change to take effect.