Обсуждение: PostgreSQL and PHP for a web site, yes but ...
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 ? :)
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@gmx.net http://yi.org/peter-e/
All,
Shouldn't PHP and Apache between them be able to come up with some sort of pooling mechanism (I thought there was one built into mod_php), to facilitate the handling of this problem. Of course, with only 16 connections, it's not going to be a high volume site, but it may temporarily alleviate the problem until a longer term solution can be constructed.
Cheers...
MikeA
-----Original Message-----
From: Peter Eisentraut
To: Richard Bayet
Cc: pgsql-admin@postgresql.org
Sent: 1-27-01 11:44 PM
Subject: Re: [ADMIN] PostgreSQL and PHP for a web site, yes but ...
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@gmx.net http://yi.org/peter-e/
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
Nick West - Global Infrastructure Manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************