TECHIES WORLD

For Techs.... Techniques.... Technologies....

AWSBashLinux

PostgreSQL Error: 'FATAL too many connections'

'FATAL too many connections'

There will be a connection limit for each PostgreSQL user. We can increase the connection limit using the following query.

>ALTER ROLE <USER> CONNECTION LIMIT <N>;

Here we need to replace USER with the username and N with the number of connections.

Please note that if we are giving -1, the number of connections will be unlimited.

That's all…

Leave a Reply