Re: Pre-forking backend

Daniel Varela Santoalla <dvs@arrakis.es>

From: Daniel Varela Santoalla <dvs@arrakis.es>
To: Lincoln Yeoh <lyeoh@pop.jaring.my>
Cc: pgsql-hackers@postgresql.org
Date: 2001-10-17T17:21:51Z
Lists: pgsql-hackers
On Mon 15 Oct 2001 04:32, you wrote:


DBBalancer (http://www.sourceforge.net/projects/dbbalancer/) does something 
like that.


>
> Create a small program that makes a few connections to postgresql, does
> some initialization, preconnects to various DBs (or maybe limited to one DB
> specified on startup), and listens on one port/socket. It might not even
> prefork, just cache connections so first connection is slow, subsequent
> ones are cached along with the user-pass for faster authentication.
>


> Then your apps can connect to that small program, authenticate, and get the
> relevant connection. Call it a "Listener" if you want ;).


-- 

----------------------------------
Regards from Spain.  Daniel Varela
----------------------------------

If you think education is expensive, try ignorance.
           -Derek Bok (Former Harvard President)