Received: from ctron-dnm.ctron.com (ctron-dnm.cabletron.com [12.25.1.120]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f79D37P75964 for ; Thu, 9 Aug 2001 09:03:07 -0400 (EDT) (envelope-from rhunter@enterasys.com) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id JAA22176; Thu, 9 Aug 2001 09:10:36 -0400 (EDT) Received: from unknown(134.141.77.96) by ctron-dnm.ctron.com via smap (4.1) id xma022130; Thu, 9 Aug 01 09:09:43 -0400 Received: by cnc-exc1.ctron.com with Internet Mail Service (5.5.2653.19) id ; Thu, 9 Aug 2001 09:02:07 -0400 Message-ID: <59358A738F45D51186A30008C74CE2500A0845@slc-exc1.ctron.com> From: "Hunter, Ray" To: "'Chris Ruprecht'" Cc: "Pgsql-php (E-mail)" Subject: RE: pg_connect vs. pg_pconnect Date: Thu, 9 Aug 2001 09:02:06 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C120D3.7DB31080" X-Archive-Number: 200108/5 X-Sequence-Number: 500 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C120D3.7DB31080 Content-Type: text/plain; charset="iso-8859-1" Chris, I am currently doing testing right now and finding that this is the case. I think that there is some kind of bug. I have to go in and manually kill the sleeping processes that are remaining after the pg_pconnect calls. Another question for you is why does pg_pconnect work when pg_connect does not. I am running into this problem as I change some of the connections to pg_connect from pg_pconnect? Thanks, RAY HUNTER Automated Test Group Software Support Engineer ENTERASYS NETWORKS rhunter@enterasys.com www.enterasys.com -----Original Message----- From: Chris Ruprecht [mailto:chrup999@yahoo.com] Sent: Thursday, August 09, 2001 6:52 AM To: Hunter, Ray Subject: Re: [PHP] pg_connect vs. pg_pconnect Ray, I had the same problem (PG 7.1.2 on RedHat 7.0) and changed the procedures to only use pg_connect. The is probably a bug in the pg_pconnect ... pg_close functions. Best regards, Chris ----- Original Message ----- From: Hunter, Ray To: Pgsql-php (E-mail) Sent: Thursday, August 09, 2001 7:42 AM Subject: RE: [PHP] pg_connect vs. pg_pconnect I am using both. When I use pg_pconnect it seems that the connections are still sleeping even after I close the connection ( pg_close( $conn ) ). RAY HUNTER Automated Test Group Software Support Engineer ENTERASYS NETWORKS Internal: 53888 Phone: 801 887-9888 Fax: 801 972-5789 Cellular: 801 698-0622 rhunter@enterasys.com www.enterasys.com -----Original Message----- From: Mitch Vincent [ mailto:mvincent@cablespeed.com ] Sent: Wednesday, August 08, 2001 6:10 PM To: Hunter, Ray; pgsql-php@postgresql.org Subject: Re: [PHP] pg_connect vs. pg_pconnect If you're using pg_connect they should be terminating... Are you using pg_connect or pg_pconnect? -Mitch Software development : You can have it cheap, fast or working. Choose two. ----- Original Message ----- From: "Hunter, Ray" To: Sent: Wednesday, August 08, 2001 7:40 PM Subject: [PHP] pg_connect vs. pg_pconnect > I understand the difference between the two functions. However, when I > watch my process under process management I notice that I have tons of > sleeping process that are lingering. How can I make it so that when I > connect to postgres and query that the connect process is then terminated? > These sleeping connections are eating up my resources. > > > Any suggestions? > > > > RAY HUNTER > Automated Test Group > Software Support Engineer > > ENTERASYS NETWORKS > > Internal: 53888 > Phone: 801 887-9888 > Fax: 801 972-5789 > Cellular: 801 698-0622 > > rhunter@enterasys.com > > www.enterasys.com > ------_=_NextPart_001_01C120D3.7DB31080 Content-Type: text/html; charset="iso-8859-1" RE: [PHP] pg_connect vs. pg_pconnect
Chris,
 
I am currently doing testing right now and finding that this is the case.  I think that there is some kind of bug.  I have to go in and manually kill the sleeping processes that are remaining after the pg_pconnect calls. 
 
Another question for you is why does pg_pconnect work when pg_connect does not.  I am running into this problem as I change some of the connections to pg_connect from pg_pconnect?
 

Thanks,


RAY HUNTER
Automated Test Group
Software Support Engineer

ENTERASYS NETWORKS

rhunter@enterasys.com

www.enterasys.com


 

-----Original Message-----
From: Chris Ruprecht [mailto:chrup999@yahoo.com]
Sent: Thursday, August 09, 2001 6:52 AM
To: Hunter, Ray
Subject: Re: [PHP] pg_connect vs. pg_pconnect

Ray,
 
I had the same problem (PG 7.1.2 on RedHat 7.0) and changed the procedures to only use pg_connect. The is probably a bug in the pg_pconnect ... pg_close functions.
 
Best regards,
Chris
 
----- Original Message -----
Sent: Thursday, August 09, 2001 7:42 AM
Subject: RE: [PHP] pg_connect vs. pg_pconnect

I am using both.  When I use pg_pconnect it seems that the connections are still sleeping even after I close the connection ( pg_close( $conn ) ).


 
 
 
RAY HUNTER
Automated Test Group
Software Support Engineer
 
ENTERASYS NETWORKS
 
Internal:    53888
Phone:       801 887-9888
Fax:         801 972-5789
Cellular:    801 698-0622

rhunter@enterasys.com
 
www.enterasys.com


-----Original Message-----
From: Mitch Vincent [mailto:mvincent@cablespeed.com]
Sent: Wednesday, August 08, 2001 6:10 PM
To: Hunter, Ray; pgsql-php@postgresql.org
Subject: Re: [PHP] pg_connect vs. pg_pconnect


If you're using pg_connect they should be terminating... Are you using
pg_connect or pg_pconnect?

-Mitch
Software development :
You can have it cheap, fast or working. Choose two.

----- Original Message -----
From: "Hunter, Ray" <rhunter@enterasys.com>
To: <pgsql-php@postgresql.org>
Sent: Wednesday, August 08, 2001 7:40 PM
Subject: [PHP] pg_connect vs. pg_pconnect


> I understand the difference between the two functions.  However, when I
> watch my process under process management I notice that I have tons of
> sleeping process that are lingering.  How can I make it so that when I
> connect to postgres and query that the connect process is then terminated?
> These sleeping connections are eating up my resources.
>
>
> Any suggestions?
>
>
>
> RAY HUNTER
> Automated Test Group
> Software Support Engineer
>
> ENTERASYS NETWORKS
>
> Internal:    53888
> Phone:       801 887-9888
> Fax:         801 972-5789
> Cellular:    801 698-0622
>
> rhunter@enterasys.com
>
> www.enterasys.com
>

------_=_NextPart_001_01C120D3.7DB31080--