Skip site navigation (1) Skip section navigation (2)

Re: Apache child processes making multiple persistent

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Apache child processes making multiple persistent
Date: 2003-02-10 07:39:51
Message-ID: 3E475747.1010009@paradise.net.nz (view raw or flat)
Thread:
Lists: pgsql-interfaces
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





In response to

pgsql-interfaces by date

Next:From: Hans-Jürgen SchönigDate: 2003-02-10 11:25:26
Subject: DBI transaction handling ...
Previous:From: Matthew VanecekDate: 2003-02-08 19:50:38
Subject: Connection Error message in ECPG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group