psql -d appdb -c "SHOW max_connections;"

Category: Databases & SQL

psql -d appdb -c "SHOW max_connections;"

Show the configured connection limit

max_connections caps concurrent backends for the whole cluster; exceeding it rejects new logins with sorry, too many clients. Raising it costs shared memory and needs a restart. Compare with connection counts from pg_stat_activity.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.