From: | Marko Kreen <marko(at)l-t(dot)ee> |
---|---|
To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
Cc: | Charles Tassell <ctassell(at)isn(dot)net>, Adam Lang <aalang(at)rutgersinsurance(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL |
Date: | 2000-11-17 01:54:12 |
Message-ID: | 20001117035411.A10861@l-t.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Thu, Nov 16, 2000 at 01:33:08PM -0400, The Hermit Hacker wrote:
> On Wed, 15 Nov 2000, Charles Tassell wrote:
>
> > Just a note, I've been using Postgres 7.02 and PHP 4.02 or 4.03 for about a
> > month in a couple sites, and haven't experienced any problems with
> > persistent connections. Problem might have been fixed in one of the point
> > releases, or maybe I just don't have enough different db connections to
> > trigger it.
>
> I run PHP4 and IMP (http://www.horde.org) and we've gotten then to remove
> the useof pg_pconnect() since it is broken. Broken how, you might
> ask? Well, I ran on a standalone machine, no other web users but myself,
> to test, and each tim eI hit the database with IMP,. it opened a new
> backend, but it never reused old, idle ones ... eventually, you run out of
> the ability to connect since you've locked up all connections ...
Maybe you have the apache maxspareservers set too high? I run
PHP4/apache (debian-woody) and it works ok. If this is only IMP
site maybe you are better off
apache.MaxClients = postgres.backendcount
Just a thought.
--
marko
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2000-11-17 01:54:26 | Re: Strange problem upgrading to 7.0.3x |
Previous Message | Tom Lane | 2000-11-17 01:28:03 | Re: I know installation questions are boring ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Warner | 2000-11-17 02:00:20 | Re: [rfc] new CREATE FUNCTION (and more) |
Previous Message | Philip Warner | 2000-11-17 01:52:45 | Re: [rfc] new CREATE FUNCTION (and more) |