Обсуждение: Max Connections

Поиск
Список
Период
Сортировка

Max Connections

От
"Ponza Giorgio"
Дата:
Hi !
I'm trying to understand postgres to build an e-commerce site.
I have a DLL that accesses to the same database with the same user.
When the requests are a lot, the postgres database responds:
 The database does not exist on the server or user authentication failed

Do you know if there are some setting like MAX_CONNECTIONS? i have the
predefined settings.

Thanks everybody


Re: Max Connections

От
"Poul L. Christiansen"
Дата:
Quote from "man postmaster":

"-N maxBackends Sets the maximum number of backend server processes that
this postmaster is allowed to start. By default, this value is 32, but
it can be set as high as 1024 if your system  will  support that  many
processes.   (Note that -B is required to be at least twice -N, so
you'll need to increase -B if you increase -N.)  Both the default and
upper  limit  values  for  -N  can  be altered when building Postgres
(see src/include/config.h)."

Meaning that the default number of backends is 32.

Poul L. Christiansen

Ponza Giorgio wrote:
>
> Hi !
> I'm trying to understand postgres to build an e-commerce site.
> I have a DLL that accesses to the same database with the same user.
> When the requests are a lot, the postgres database responds:
>  The database does not exist on the server or user authentication failed
>
> Do you know if there are some setting like MAX_CONNECTIONS? i have the
> predefined settings.
>
> Thanks everybody