Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-24 Thread Hannes Dorbath
On 24.08.2007 02:43, Bill Moran wrote: Hannes Dorbath [EMAIL PROTECTED] wrote: Bill Moran wrote: I guess I just feel that broken is a bit of a harsh term. If your expectations are for full-blown connection management from pconnect(), then you will be disappointed. If you take it for what it

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-24 Thread Hannes Dorbath
On 24.08.2007 00:43, Hannes Dorbath wrote: Bill Moran wrote: I guess I just feel that broken is a bit of a harsh term. If your expectations are for full-blown connection management from pconnect(), then you will be disappointed. If you take it for what it is: persistent connections, then

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-24 Thread Bill Moran
In response to Hannes Dorbath [EMAIL PROTECTED]: On 24.08.2007 02:43, Bill Moran wrote: Hannes Dorbath [EMAIL PROTECTED] wrote: Bill Moran wrote: I guess I just feel that broken is a bit of a harsh term. If your expectations are for full-blown connection management from pconnect(),

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-24 Thread Hannes Dorbath
On 24.08.2007 12:56, Bill Moran wrote: How did you verify that? It will spawn a new connection silently, if the old got dropped. Did you really verify your logs, that you don't get more new connections than Apache spawns workers? This might not be noticeable for you, if you are running Apache.

[GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Max Zorloff
Hello. I have a subject setup and a few questions. The first one is this. PHP establishes a connection to the Postgres database through pg_pconnect(). Then it runs some query, then the script returns, leaving the persistent connection hanging. But the trouble is that in this case any query

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Max Zorloff wrote: Hello. I have a subject setup and a few questions. The first one is this. PHP establishes a connection to the Postgres database through pg_pconnect(). Don't use pconnect. Use pgbouncer or pgpool. Then it runs some

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Bill Moran
In response to Joshua D. Drake [EMAIL PROTECTED]: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Max Zorloff wrote: Hello. I have a subject setup and a few questions. The first one is this. PHP establishes a connection to the Postgres database through pg_pconnect(). Don't

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Erik Jones
On Aug 23, 2007, at 12:29 PM, Bill Moran wrote: In response to Joshua D. Drake [EMAIL PROTECTED]: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Max Zorloff wrote: Hello. I have a subject setup and a few questions. The first one is this. PHP establishes a connection to the Postgres

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Josh Trutwin
On Thu, 23 Aug 2007 13:29:46 -0400 Bill Moran [EMAIL PROTECTED] wrote: Well you haven't given us any indication of data set or what you are trying to do. However, I can tell you, don't use pconnect, its broke ;) Broke? How do you figure? I asked that question earlier this month - this

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Max Zorloff
On Thu, 23 Aug 2007 21:16:48 +0400, Joshua D. Drake [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Max Zorloff wrote: Hello. I have a subject setup and a few questions. The first one is this. PHP establishes a connection to the Postgres database through

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Max Zorloff
On Thu, 23 Aug 2007 21:29:46 +0400, Bill Moran [EMAIL PROTECTED] wrote: In response to Joshua D. Drake [EMAIL PROTECTED]: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Max Zorloff wrote: Hello. I have a subject setup and a few questions. The first one is this. PHP establishes a

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Bill Moran
In response to Josh Trutwin [EMAIL PROTECTED]: On Thu, 23 Aug 2007 13:29:46 -0400 Bill Moran [EMAIL PROTECTED] wrote: Well you haven't given us any indication of data set or what you are trying to do. However, I can tell you, don't use pconnect, its broke ;) Broke? How do you

Re: [GENERAL] Apache + PHP + Postgres Interaction

2007-08-23 Thread Hannes Dorbath
Bill Moran wrote: I guess I just feel that broken is a bit of a harsh term. If your expectations are for full-blown connection management from pconnect(), then you will be disappointed. If you take it for what it is: persistent connections, then those limitations would be expected. It's