sdv mailer wrote:
> I'm talking about connecting to multiple database
> servers on separate machines. Schemas don't apply
> here.
>
> How much work would it take to make a pre-fork smart
> enough to open different databases on incoming
> connection? How much of it can be modeled after
> Apache?
>
I've not used it but Tatsuo Ishii has just released pgpool v1.0. Quoting
from its README:
1. What is pgpool
pgpool is a connection server program for PostgreSQL. pgpool runs between PostgreSQL's client(frontend) and
server(backend).Any PostgreSQL clients can connect to pgpool as if it's a real PostgreSQL server.
pgpool caches the connection to PostgreSQL server to reduce the overhead to establish the connection to it.
Also pgpool could use two PostgreSQL servers for fail over purpose. If the first server goes down, pgpool will
automatically switch to the secondary server.
If that's not what you're after, then it must be fairly close. Check the
mailing list archives - the download URL is on the "announce" list April
2004.
I'm sure any real figures from your testing will be of much interest to
all of us.
HTH
-- Richard Huxton Archonet Ltd
