RE: PostgreSQL and PHP for a web site, yes but ... - Mailing list pgsql-admin

From Michael Ansley
Subject RE: PostgreSQL and PHP for a web site, yes but ...
Date
Msg-id 7F124BC48D56D411812500D0B747251480F3B0@FILESERVER002
Whole thread Raw
In response to PostgreSQL and PHP for a web site, yes but ...  (Richard Bayet <bayet@enseirb.fr>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: andrew@ernie.2sheds.de
Date:
Subject: Re: postgres limitation
Next
From: Bruce Momjian
Date:
Subject: Re: postgres limitation