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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
