Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_connect vs. pg_pconnect

pg_connect vs. pg_pconnect

From
"Hunter, Ray"
Date:

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

Re: pg_connect vs. pg_pconnect

From
"Mitch Vincent"
Date:
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
>

RE: pg_connect vs. pg_pconnect

From
"Hunter, Ray"
Date:

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
>

RE: pg_connect vs. pg_pconnect

From
"Hunter, Ray"
Date:
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
>

RE: pg_connect vs. pg_pconnect

From
"Hunter, Ray"
Date:
Chris,
 
I am including the php source that has the pg_pconnect and the problems.  On one php page, I am query the database multilple times to get specific data in order to populate a table for our engineers.
 
I have to use it on the create_sub_table function.
 
I have no idea why it does not work. 




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: Chris Ruprecht [mailto:chrup999@yahoo.com]
Sent: Thursday, August 09, 2001 7:21 AM
To: Hunter, Ray
Subject: Re: [PHP] pg_connect vs. pg_pconnect

Hi Ray,
 
I don't know why pg_connect wouldn't work for you. It works in every procedure I have ever written (not all that many and not very complicated ones). I'm not much help when it comes to fixing the C sources, Tom Lane or Bruce Momijan are the people to talk to here.
Can you send me an example of one of the pg_connects which doesn't work? What is the error message you're getting?
 
Best regards,
Chris
 
----- Original Message -----
Sent: Thursday, August 09, 2001 8:02 AM
Subject: 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
>

Attachment

RE: pg_connect vs. pg_pconnect

From
"Brent R. Matzelle"
Date:
--- "Hunter, Ray" <rhunter@enterasys.com> wrote:
> 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.

There are two open PHP bug reports that deal with your issue.

http://www.php.net/bugs.php?id=8769
http://www.php.net/bugs.php?id=12558

Brent

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

RE: RE: pg_connect vs. pg_pconnect

From
"Hunter, Ray"
Date:

Thanks Brent for the heads up on this issue.  I will read the bug reports and find out what I need to do.

Thanks again to Chris for the additional info.
 
 
 
RAY HUNTER
Automated Test Group
Software Support Engineer
 
ENTERASYS NETWORKS
rhunter@enterasys.com
 
www.enterasys.com

-----Original Message-----
From: Brent R. Matzelle [mailto:bmatzelle@yahoo.com]
Sent: Thursday, August 09, 2001 7:36 AM
To: pgsql-php@postgresql.org
Subject: [PHP] RE: pg_connect vs. pg_pconnect

--- "Hunter, Ray" <rhunter@enterasys.com> wrote:
> 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. 

There are two open PHP bug reports that deal with your issue.

http://www.php.net/bugs.php?id=8769
http://www.php.net/bugs.php?id=12558

Brent

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

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

RE: pg_connect vs. pg_pconnect

From
"Brent R. Matzelle"
Date:
--- "Hunter, Ray" <rhunter@enterasys.com> wrote:
> Chris,
>
> I am including the php source that has the pg_pconnect and the
> problems.  On
> one php page, I am query the database multilple times to get
> specific data
> in order to populate a table for our engineers.
>
> I have to use it on the create_sub_table function.
>
> I have no idea why it does not work.

I personally never mix connection types as I always use
pg_pconnect() for every connection call.  I consistently get one
PostgreSQL process for each Apache process.

Your code opens up a new PostgreSQL connection for each function
call, except for create_sub_table().  As a result, you can have
many idle database processes for each httpd process.  You can
count on each non-pg_pconnect() connection to linger for a
minute or so and that will eat all your system resources with
only a few simultaneous users.

Brent

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

RE: pg_connect vs. pg_pconnect

From
"Hunter, Ray"
Date:
I took the advise of Brent Matzelle about 'not mixing connections' and switched to using pg_connect.  This has solved all my problems.  I am currently using php4.0.4pl1-9 and postgres 7.0.3 on Redhat 7.1.
 
I have no connections that are persisent and found that even with all my queries I can use the same connection.





RAY HUNTER
Automated Test Group
Software Support Engineer

ENTERASYS NETWORKS

rhunter@enterasys.com

www.enterasys.com

-----Original Message-----
From: Leonello, Chris (C.R.) [mailto:cleonell@visteon.com]
Sent: Friday, August 10, 2001 11:45 AM
To: 'Hunter, Ray'; 'Chris Ruprecht'
Cc: Pgsql-php (E-mail)
Subject: RE: pg_connect vs. pg_pconnect

Note that pg_close will not close persistent links (this is stated in the docs).  I have not found anything in the PHP docs that indicates what will close a persistent connection.
 
However, I do believe there is a bug.  I noticed with php version 4.03pl1 and PostgreSQL 7.03 that I would receive errors like "not a valid PostgreSQL result resource" when trying use persistent connections and had dozens of lingering postgres processes.  Apparently, not only was PHP not detecting existing open persistent connections and using them, it was then getting confused as it opened new connections.  I did not have this problem with an earlier version of PHP (possibly 4.01?) that I was using on a development server.  When I switched to pg_connect, the problem disappeared.
 
There are bug reports on php.net relating to this problem, (#8769, #12558, #11771, ...).  There have been other posts to the list (2/5/01 and 4/18/01) which I believe all point to this same problem with persistent connections not working and/or lingering forever.  I don't have any solutions, but I would be interested to hear from anyone having similar problems because I think this is wide spread (for those using p_connect).  Maybe we will stumble across some solution or I will gather enough info to put together one coherent and specific bug report.  Current bug reports are either closed because the were too vague, closed with the response that persistent connections are not supposed to close (never ever close...?) or still unassigned.
-----Original Message-----
From: Hunter, Ray [mailto:rhunter@enterasys.com]
Sent: Thursday, August 09, 2001 9:02 AM
To: 'Chris Ruprecht'
Cc: Pgsql-php (E-mail)
Subject: RE: 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
>

RE: pg_connect vs. pg_pconnect

From
"Leonello, Chris (C.R.)"
Date:
Note that pg_close will not close persistent links (this is stated in the docs).  I have not found anything in the PHP docs that indicates what will close a persistent connection.
 
However, I do believe there is a bug.  I noticed with php version 4.03pl1 and PostgreSQL 7.03 that I would receive errors like "not a valid PostgreSQL result resource" when trying use persistent connections and had dozens of lingering postgres processes.  Apparently, not only was PHP not detecting existing open persistent connections and using them, it was then getting confused as it opened new connections.  I did not have this problem with an earlier version of PHP (possibly 4.01?) that I was using on a development server.  When I switched to pg_connect, the problem disappeared.
 
There are bug reports on php.net relating to this problem, (#8769, #12558, #11771, ...).  There have been other posts to the list (2/5/01 and 4/18/01) which I believe all point to this same problem with persistent connections not working and/or lingering forever.  I don't have any solutions, but I would be interested to hear from anyone having similar problems because I think this is wide spread (for those using p_connect).  Maybe we will stumble across some solution or I will gather enough info to put together one coherent and specific bug report.  Current bug reports are either closed because the were too vague, closed with the response that persistent connections are not supposed to close (never ever close...?) or still unassigned.
-----Original Message-----
From: Hunter, Ray [mailto:rhunter@enterasys.com]
Sent: Thursday, August 09, 2001 9:02 AM
To: 'Chris Ruprecht'
Cc: Pgsql-php (E-mail)
Subject: RE: 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
>

RE: pg_connect vs. pg_pconnect

From
"Brent R. Matzelle"
Date:
--- "Hunter, Ray" <rhunter@enterasys.com> wrote:
> I took the advise of Brent Matzelle about 'not mixing
> connections' and
> switched to using pg_connect.  This has solved all my
> problems.  I am
> currently using php4.0.4pl1-9 and postgres 7.0.3 on Redhat
> 7.1.
>
> I have no connections that are persisent and found that even
> with all my
> queries I can use the same connection.

I am glad that it is working correctly.  Also, I also have had
problems with connections when trying to use pg_pconnect() while
specifying a remote database host.  This is true with several of
the PHP *_pconnect() functions that I have tested.  So my rule
of thumb is use pg_pconnect() only if the database is located on
the localhost, otherwise use pg_connect().

Brent

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

List Archive?

From
"Josh Berkus"
Date:
Folks,

I need to search this list archive for issues about connections not
terminating.  However, I can't find the archive ... it doesn't appear to
be on postgresql.org.  Can anyone point me in the right direction?

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Re: List Archive?

From
Dorin Grunberg
Date:
Try this:

http://www.geocrawler.com/lists/3/Web/11/0/


dorin

At 09:29 AM 8/14/01 -0700, Josh Berkus wrote:
Folks,

I need to search this list archive for issues about connections not
terminating.  However, I can't find the archive ... it doesn't appear to
be on postgresql.org.  Can anyone point me in the right direction?

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: List Archive?

From
"Josh Berkus"
Date:
Folks:

Thanks for the links.  Turns out my problem was an actual Deadlock, and
not a hung PHP connection after all ...

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Re: pg_connect vs. pg_pconnect

From
"Hunter, Ray"
Date:
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
>

Re: pg_connect vs. pg_pconnect

From
"Hunter, Ray"
Date:
Chris,
 
I am including the php source that has the pg_pconnect and the problems.  On one php page, I am query the database multilple times to get specific data in order to populate a table for our engineers.
 
I have to use it on the create_sub_table function.
 
I have no idea why it does not work. 




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: Chris Ruprecht [mailto:chrup999@yahoo.com]
Sent: Thursday, August 09, 2001 7:21 AM
To: Hunter, Ray
Subject: Re: [PHP] pg_connect vs. pg_pconnect

Hi Ray,
 
I don't know why pg_connect wouldn't work for you. It works in every procedure I have ever written (not all that many and not very complicated ones). I'm not much help when it comes to fixing the C sources, Tom Lane or Bruce Momijan are the people to talk to here.
Can you send me an example of one of the pg_connects which doesn't work? What is the error message you're getting?
 
Best regards,
Chris
 
----- Original Message -----
Sent: Thursday, August 09, 2001 8:02 AM
Subject: 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
>

Attachment