Re: Max Connections - Mailing list pgsql-novice

From Poul L. Christiansen
Subject Re: Max Connections
Date
Msg-id 39DC4EE9.F8A97720@cs.auc.dk
Whole thread Raw
In response to Max Connections  ("Ponza Giorgio" <giorgio@opla.it>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "Ponza Giorgio"
Date:
Subject: Max Connections
Next
From: Vic
Date:
Subject: How I exec sheel script from Postrgres Function ???