Moodle 3.5 AWS PostgresSQL Max_Connections

Moodle 3.5 AWS PostgresSQL Max_Connections

by Gabriel Caride -
Number of replies: 1

Hi to everyone! 

We currently have Moodle installed from this template and the strange thing is that our connections in the DB do not exceed 100. I understand that with MySQL this can be a problem, but it is not the case with PostgreSQL.

Our database is AWS Aurora PostgreSQL Cluster with 2 instances db.r4.xlarge and db.r4.2xlarge and are enough to support 100 users simultaneously but we see that this value of 100 is not passed and it produces cases of crashes



Our Moodle Cluster are running on 2 EC2 Instances t2.xlarge (4 vcpu 16GB)

We currently have more than 400 users simultaneously.

What values should I look at or look at? I've been looking at previous cases on the forum but didn't find anything.

This is our configuration size:

  • PHP Version 7.2.33
  • Database: Aurora PostgreSQL Cluster (db.r4.xlarge and db.r4.2xlarge)
  • Moodle Version: 3.5 (Build: 20180517)

What values can we see or modify so that this does not happen?

Thank you very much to all!

Average of ratings: -
In reply to Gabriel Caride

Re: Moodle 3.5 AWS PostgresSQL Max_Connections

by Gabriel Caride -
Hi, could any one please help me? I still have this problem, but i don't know what more to see.

I ran a pgbench and my database can go up to 2000 DB Connections, so RDS Postgres is not the problem!