PostgreSQL and PHP for a web site, yes but ...

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/