Lists: | pgsql-admin |
---|
From: | Richard Bayet <bayet(at)enseirb(dot)fr> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | PostgreSQL and PHP for a web site, yes but ... |
Date: | 2001-01-27 23:32:55 |
Message-ID: | 3A735AA7.2EBBBDF2@enseirb.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
How do I set up (here, to extend it) the maximum number of clients for a
database ?
I start postmaster with 'postmaster -i -N 16' (I can't use more than 16
due to the IPC sys V blabla ...).
I know N is the number of backend server processes, but does it have a
result on the maximum number of clients ?
Here's the problem i have on the web site i'm currently developping:
Unable to connect to PostgreSQL server: "Sorry, too many clients already
in -file i'm using to open the connection-" (i only open the connectiion
if there isn't one already opened) ...
Here's the stuff from php.ini:
[PostgresSQL]
pgsql.allow_persistent = On ; allow or prevent persistent link
pgsql.max_persistent = -1 ; maximum number of persistent links. -1 means
no limit
pgsql.max_links = -1 ; maximum number of links (persistent+non
persistent). -1 means no limit
So, it looks like the problem isn't coming from PHP ...
I'm worrying a bit because PostgreSQL is supposed to be a good choice
for dynamic web sites, but eh ... will i be able to have more than a
handful of visitors at the same time ? :)
From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Richard Bayet <bayet(at)enseirb(dot)fr> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL and PHP for a web site, yes but ... |
Date: | 2001-01-27 23:44:32 |
Message-ID: | Pine.LNX.4.30.0101280043250.1492-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Richard Bayet writes:
> How do I set up (here, to extend it) the maximum number of clients for a
> database ?
Use the -N option.
> I start postmaster with 'postmaster -i -N 16' (I can't use more than 16
> due to the IPC sys V blabla ...).
Time to do something about the IPC sys V blablah then.
> I know N is the number of backend server processes, but does it have a
> result on the maximum number of clients ?
One backend server process per client.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/