Thread: Transaction Manager

I don't know if this is totally related to PostgreSQL, but in some fashion I
suppose
it pertains.

Is there a reliable open source transaction monitor/manager for Linux that
works with
Postgres and Apache?

I'm looking for something like MTS on the NT platform, something that would
have some
"pooling" and intellegent transaction management...

Thanks in advance.
Gary
FreeportWeb, Inc.

pgsql-general-owner@hub.org wrote:

>I don't know if this is totally related to PostgreSQL, but in some fashion I
>suppose
>it pertains.
>
>Is there a reliable open source transaction monitor/manager for Linux that
>works with
>Postgres and Apache?
>
>I'm looking for something like MTS on the NT platform, something that would
>have some
>"pooling" and intellegent transaction management...

mod_perl will do pooling automatically if you use DBI. It will even pool database handles for your CGI scripts, which
wouldotherwise establish one connection per request. 

Brian

On Mon, Sep 11, 2000 at 04:22:48PM +0800, Brian Baquiran wrote:
> pgsql-general-owner@hub.org wrote:
> >I'm looking for something like MTS on the NT platform, something that would
> >have some
> >"pooling" and intellegent transaction management...
>
> mod_perl will do pooling automatically if you use DBI. It will even pool database handles for your CGI scripts, which
wouldotherwise establish one connection per request. 

Note this this is part of a separate module, Apache::DBI. It's not
installed by default with mod_perl, and needs to be configured
separately. However, it is a really neat module. If you're doing
web stuff with databases and Perl, I'd strongly suggest looking into it.

Regards,

Neil

--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

I've made up my mind.  Don't try to confuse me with the facts.
        -- Indiana Senator Earl Landgrebe

Thanks Brian, thats actually good to know
Does anyone know if the libpq++ pools connections?

Thanks
Gary
----- Original Message -----
From: "Brian Baquiran" <brian@climbers.ph>
To: <pgsql-general@hub.org>
Sent: Monday, September 11, 2000 4:22 AM
Subject: Re: [GENERAL] Transaction Manager


>
> pgsql-general-owner@hub.org wrote:
>
> >I don't know if this is totally related to PostgreSQL, but in some
fashion I
> >suppose
> >it pertains.
> >
> >Is there a reliable open source transaction monitor/manager for Linux
that
> >works with
> >Postgres and Apache?
> >
> >I'm looking for something like MTS on the NT platform, something that
would
> >have some
> >"pooling" and intellegent transaction management...
>
> mod_perl will do pooling automatically if you use DBI. It will even pool
database handles for your CGI scripts, which would otherwise establish one
connection per request.
>
> Brian