How to change max_connections for Postgres through SQL command

Apparently, the hosted Postgres we are using does not provide this option. (compose.io)

So the work around is to use a pgbouncer to manage you connections better.

Changing max_connection parameter needs a Postgres restart

Commands

Check max_connection just to keep current value in mind
```
SHOW max_connections;
```

Change max_connection value

ALTER SYSTEM SET max_connections TO '500';

Related