Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Richard Bayet
Date:
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 ? :)

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

From
Peter Eisentraut
Date:
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/

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

From
Michael Ansley
Date:

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
**********************************************************************