Re: Postgre and Web Request - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: Postgre and Web Request
Date
Msg-id Pine.GSO.4.58.0404291920480.9920@ra.sai.msu.su
Whole thread Raw
In response to Re: Postgre and Web Request  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: Postgre and Web Request
List pgsql-general
On Thu, 29 Apr 2004, Tatsuo Ishii wrote:

> > > Depending on your web development environment (java, php, .NET) etc,
> > > you should be able to use some mechanism that will provide a pool of
> > > connections to the database. Each request does not open a new
> > > connection (and then release it), but insteads gets a connection from
> > > the pool to use, and returns it back to the pool when done.
> >
> > Where can I find some examples for connection pooling with php? Or must I
> > just use persistence connections?
>
> Use pgpool
> (ftp://ftp.sra.co.jp/pub/cmd/postgres/pgpool/pgpool-1.1.tar.gz).

Tatsuo, I just tried pgpool (not replication yet) and noticed warnings appear
in pgsql.log:
(I just changed port number in my perl script to 9999)

Apr 29 19:19:59 mira postgres[363]: [4-1] WARNING:  there is no transaction in progress


    Oleg
> --
> Tatsuo Ishii
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

pgsql-general by date:

Previous
From: Richard Welty
Date:
Subject: Re: Anyone using pgreplicator?
Next
From: Manfred Koizar
Date:
Subject: Re: Unable to use index?