Database connections management
Moderator: crythias
Database connections management
At 0 hours we have 15 database connections, but we don't have any user or agent connected. We are working with postgre. We don't see any configuration parameter. How can we manage it?
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
Re: Database connections management
shutdown apache and OTRS cronjobs
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Database connections management
Really the question is how many connections needs OTRS to work on postgre. We need it to dimensioning our database.
thanks
thanks
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
Re: Database connections management
every running apache child will need a connection. all jobs running by cron need also a connection
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Database connections management
And what about customers? If we have 5 different customers connectes, we need 5 connections?
Thanks.
Thanks.
Using:
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
OTRS HELP DESK 3.3.5
OTRS ITSM 3.3.5
POSTGRES 8.3
Re: Database connections management
all users (agents and customers) will need an apache child if they are concurrent
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com