How to change max_connections for Postgres through SQL command

Question

We have a hosted PostgreSQL, with no access to the system or *.conf files.

I do have a admin access and can connect to it using Oracle SQL developer. Can I run any command to increase the max_connections. All other parameters seems to be ok shared mem and buffers can hold more connections so there is not problem there.

alter system: postgresql.org/docs/current/static/sql-altersystem.html — user330315
– user330315, Commented Mar 18, 2016 at 13:22

Sachin Gupta · Accepted Answer · 2019-10-14 09:28:43Z

55

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';

Restart PostgreSQL server

edited Oct 14, 2019 at 9:28

user330315

answered Oct 14, 2019 at 9:26

Sachin Gupta

1,82519 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

700 Software Over a year ago

I had done step 2 without restarting recently and it bit me.

Prasanna Bableshwar · Accepted Answer · 2019-10-14 09:28:04Z

1

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.

edited Oct 14, 2019 at 9:28

user330315

answered Apr 25, 2016 at 7:26

Prasanna Bableshwar

2871 gold badge3 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to change max_connections for Postgres through SQL command

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related