PostgreSQL connection saturation observation at 12 API replicas; no credentials or message content recorded.
$ docker compose --env-file .env ps api
NAME                   IMAGE                                                                     COMMAND              SERVICE   CREATED              STATUS                        PORTS
mtusi2026lab3-api-10   sha256:4833b59a6d4c8406b779432843914b72e61ee92aecd4325e4d034e6839f2ff57   "python server.py"   api       45 minutes ago       Up 45 minutes (healthy)       8080/tcp
mtusi2026lab3-api-11   mtusi2026lab3-api                                                         "python server.py"   api       About a minute ago   Up About a minute (healthy)   8080/tcp
mtusi2026lab3-api-12   mtusi2026lab3-api                                                         "python server.py"   api       About a minute ago   Up About a minute (healthy)   8080/tcp
mtusi2026lab3-api-13   mtusi2026lab3-api                                                         "python server.py"   api       About a minute ago   Up About a minute (healthy)   8080/tcp
mtusi2026lab3-api-14   mtusi2026lab3-api                                                         "python server.py"   api       About a minute ago   Up About a minute (healthy)   8080/tcp
mtusi2026lab3-api-3    sha256:5f93cf319bad7c0e5f360f38e3e3f07708f2357101f6c5804f0194b1a02377cd   "python server.py"   api       50 minutes ago       Up 50 minutes (healthy)       8080/tcp
mtusi2026lab3-api-4    sha256:5f93cf319bad7c0e5f360f38e3e3f07708f2357101f6c5804f0194b1a02377cd   "python server.py"   api       50 minutes ago       Up 50 minutes (healthy)       8080/tcp
mtusi2026lab3-api-5    sha256:5f93cf319bad7c0e5f360f38e3e3f07708f2357101f6c5804f0194b1a02377cd   "python server.py"   api       50 minutes ago       Up 50 minutes (healthy)       8080/tcp
mtusi2026lab3-api-6    sha256:5f93cf319bad7c0e5f360f38e3e3f07708f2357101f6c5804f0194b1a02377cd   "python server.py"   api       50 minutes ago       Up 50 minutes (healthy)       8080/tcp
mtusi2026lab3-api-7    sha256:4833b59a6d4c8406b779432843914b72e61ee92aecd4325e4d034e6839f2ff57   "python server.py"   api       45 minutes ago       Up 45 minutes (healthy)       8080/tcp
mtusi2026lab3-api-8    sha256:4833b59a6d4c8406b779432843914b72e61ee92aecd4325e4d034e6839f2ff57   "python server.py"   api       45 minutes ago       Up 45 minutes (healthy)       8080/tcp
mtusi2026lab3-api-9    sha256:4833b59a6d4c8406b779432843914b72e61ee92aecd4325e4d034e6839f2ff57   "python server.py"   api       45 minutes ago       Up 45 minutes (healthy)       8080/tcp
exit_code=0
$ docker compose --env-file .env exec -T postgres psql -U messenger -d messenger -Atc SHOW max_connections; SELECT count(*) FROM pg_stat_activity;
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  sorry, too many clients already
exit_code=2
$ compose scale to 8 API replicas
Container mtusi2026lab3-postgres-1 Running
 Container mtusi2026lab3-valkey-1 Running
 Container mtusi2026lab3-haproxy-1 Running
 Container mtusi2026lab3-api-6 Recreate
 Container mtusi2026lab3-api-12 Stopping
 Container mtusi2026lab3-api-3 Recreate
 Container mtusi2026lab3-api-11 Stopping
 Container mtusi2026lab3-api-7 Recreate
 Container mtusi2026lab3-api-13 Stopping
 Container mtusi2026lab3-api-5 Recreate
 Container mtusi2026lab3-api-14 Stopping
 Container mtusi2026lab3-api-10 Recreate
 Container mtusi2026lab3-api-4 Recreate
 Container mtusi2026lab3-api-9 Recreate
 Container mtusi2026lab3-api-8 Recreate
 Container mtusi2026lab3-api-11 Stopped
 Container mtusi2026lab3-api-11 Removing
 Container mtusi2026lab3-api-11 Removed
 Container mtusi2026lab3-api-13 Stopped
 Container mtusi2026lab3-api-13 Removing
 Container mtusi2026lab3-api-13 Removed
 Container mtusi2026lab3-api-14 Stopped
 Container mtusi2026lab3-api-14 Removing
 Container mtusi2026lab3-api-14 Removed
 Container mtusi2026lab3-api-12 Stopped
 Container mtusi2026lab3-api-12 Removing
 Container mtusi2026lab3-api-12 Removed
 Container mtusi2026lab3-api-3 Recreated
 Container mtusi2026lab3-api-7 Recreated
 Container mtusi2026lab3-api-9 Recreated
 Container mtusi2026lab3-api-4 Recreated
 Container mtusi2026lab3-api-6 Recreated
 Container mtusi2026lab3-api-8 Recreated
 Container mtusi2026lab3-api-10 Recreated
 Container mtusi2026lab3-api-5 Recreated
 Container mtusi2026lab3-postgres-1 Waiting
 Container mtusi2026lab3-valkey-1 Waiting
 Container mtusi2026lab3-valkey-1 Healthy
 Container mtusi2026lab3-postgres-1 Healthy
 Container mtusi2026lab3-migrate-1 Starting
 Container mtusi2026lab3-migrate-1 Started
 Container mtusi2026lab3-valkey-1 Waiting
 Container mtusi2026lab3-migrate-1 Waiting
 Container mtusi2026lab3-valkey-1 Healthy
 Container mtusi2026lab3-migrate-1 Exited
 Container mtusi2026lab3-api-5 Starting
 Container mtusi2026lab3-api-5 Started
 Container mtusi2026lab3-api-3 Starting
 Container mtusi2026lab3-api-3 Started
 Container mtusi2026lab3-api-6 Starting
 Container mtusi2026lab3-api-6 Started
 Container mtusi2026lab3-api-7 Starting
 Container mtusi2026lab3-api-7 Started
 Container mtusi2026lab3-api-4 Starting
 Container mtusi2026lab3-api-4 Started
 Container mtusi2026lab3-api-8 Starting
 Container mtusi2026lab3-api-8 Started
 Container mtusi2026lab3-api-9 Starting
 Container mtusi2026lab3-api-9 Started
 Container mtusi2026lab3-api-10 Starting
 Container mtusi2026lab3-api-10 Started
 Container mtusi2026lab3-valkey-1 Waiting
 Container mtusi2026lab3-haproxy-1 Waiting
 Container mtusi2026lab3-migrate-1 Waiting
 Container mtusi2026lab3-api-5 Waiting
 Container mtusi2026lab3-api-3 Waiting
 Container mtusi2026lab3-api-6 Waiting
 Container mtusi2026lab3-api-7 Waiting
 Container mtusi2026lab3-api-4 Waiting
 Container mtusi2026lab3-api-8 Waiting
 Container mtusi2026lab3-api-9 Waiting
 Container mtusi2026lab3-api-10 Waiting
 Container mtusi2026lab3-postgres-1 Waiting
 Container mtusi2026lab3-haproxy-1 Healthy
 Container mtusi2026lab3-valkey-1 Healthy
 Container mtusi2026lab3-postgres-1 Healthy
 Container mtusi2026lab3-migrate-1 Exited
 Container mtusi2026lab3-api-5 Healthy
 Container mtusi2026lab3-api-3 Healthy
 Container mtusi2026lab3-api-6 Healthy
 Container mtusi2026lab3-api-7 Healthy
 Container mtusi2026lab3-api-4 Healthy
 Container mtusi2026lab3-api-8 Healthy
 Container mtusi2026lab3-api-9 Healthy
 Container mtusi2026lab3-api-10 Healthy
exit_code=0
$ query PostgreSQL connection limit and count after scale down
100
15
exit_code=0
