How to change the postgresql.conf parameter on Google Cloud SQL

Question

How to change the postgresql.conf parameter "max_connections" on Google Cloud SQL?

When I exceed 100 connections I get the error: "FATAL: remaining connection slots are reserved for non-replication superuser connections"

Answer 1

Normally you would do it via CloudSQL flags API (or UI): https://cloud.google.com/sql/docs/postgres/flags

However, max_connections is not a parameter we currently support. We (Postgres team in CloudSQL) are aware that low max_connections is a problem for some (many?) applications and will address issue in one of the next releases.

Please follow issue 37271935 on our public issue tracker for updates.