the new session will exit suddenly when the session exceed 8 on multisession LVDA

the new session will exit suddenly when the session exceed 8 on multisession LVDA

book

Article ID: CTX691445

calendar_today

Updated On:

Description

The customer said the new session will exit suddenly when the session exceed 8 on multisession LVDA. And if logoff 1 session, the user can login succeesfully.

Resolution

modify max_connections from 100 to 1000 under /var/lib/pgsql/data/postgresql.conf on LVDA

Problem Cause

the connection to database exceed the limit so all new connection to database will met error