From: Mark Kirkwood <markir@paradise.net.nz>
To: pgsql-interfaces@postgresql.org
Subject: Re: Apache child processes making multiple persistent
Date: Mon, 10 Feb 2003 20:39:51 +1300
Message-ID: <3E475747.1010009@paradise.net.nz> (raw)
References: <b1f5hd$e0d$1@news.hub.org>
Ben Borger wrote:
> Hello,
>
> Is it normal for Apache child threads to be opening more than one
> persistent
> database connection to Postgres? DBI 1.19, Apache::DBI 0.88
>
>
>
How I think it works is :
Each connection to the db for a userid and an apache child results in a
persistent connection.
So if user1, user2 both get serviced by apache child 1, then it ends up
with a persistent connection for each of them.
How this problem is often circumvented is to authenticate externally,
save credentials (or an id for them) in a cookie, and do all db work by
means 1 synthetic database userid.
best wishes
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: markir@paradise.net.nz
Subject: Re: Apache child processes making multiple persistent
In-Reply-To: <3E475747.1010009@paradise.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox