Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Please clarify max_connections, MAX_SIZE parameter usage #135

Closed
mrechte opened this issue Feb 5, 2021 · 1 comment
Closed

Please clarify max_connections, MAX_SIZE parameter usage #135

mrechte opened this issue Feb 5, 2021 · 1 comment
Assignees
Labels
documentation Improvements or additions to documentation enhancement Improvement to an existing feature

Comments

@mrechte
Copy link

mrechte commented Feb 5, 2021

I am completely lost with theses parameters usage.
In pgagroal.conf, max_connections is the limit of total number of connections from client -> pgagroal ?
In pgagroal_database.conf, MAX_SIZE is the limit for client -> pgagroal (for a given user/database) ?
How do I control the number of connections from pgagroal -> PG server ?
Does one pgagroal instance manages one pool, or can I have several ?
Thanks for clarifications

@mrechte mrechte added the bug Something isn't working label Feb 5, 2021
@jesperpedersen jesperpedersen self-assigned this Feb 8, 2021
@jesperpedersen jesperpedersen removed the bug Something isn't working label Feb 8, 2021
@jesperpedersen
Copy link
Collaborator

All numbers are from pgagroal to PostgreSQL.

There are currently no settings for clients other than blocking_timeout (and disconnect_client).

So, you sub divide your max_connections to each database using the pgagroal_databases.conf file.

You can use https://github.com/agroal/pgagroal/discussions for questions.

Thanks !

@jesperpedersen jesperpedersen added documentation Improvements or additions to documentation enhancement Improvement to an existing feature labels Feb 23, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation enhancement Improvement to an existing feature
Projects
None yet
Development

No branches or pull requests

2 participants