Database connection pool and max_connections

zammad-docker-compose 2.5

I noticed config/database.yml has a setting “pool 50”, I had max_connections in postgres set to 100 thinking it’s not going to use more than 50, but it used up all of the 100 and was trying to use more, looking in the nginx logs only /api/v1/users were getting http service code 500 due to max_connections. What’s happening there?

I can’t understand why it was using more than 50 connections, and why I only saw /api/v1/users with errors, It’s like /api/v1/users requests aren’t using the connection pool?

1 Like

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.