psql -d postgres -c "ALTER SYSTEM SET max_connections = '200';"

Category: Databases & SQL

psql -d postgres -c "ALTER SYSTEM SET max_connections = '200';"

Raise the cluster-wide connection limit

Sets max_connections via postgresql.auto.conf. This parameter needs a full restart to take effect because shared memory is sized at startup. After restarting, confirm with SHOW max_connections.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.