Re: pg_connect vs. pg_pconnect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Title: RE: [PHP] pg_connect vs. pg_pconnect
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@xxxxxxxxxxxxx

www.enterasys.com
-----Original Message-----
From: Chris Ruprecht [mailto:chrup999@xxxxxxxxx]
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@xxxxxxxxxxxxx

www.enterasys.com


 

-----Original Message-----
From: Chris Ruprecht [mailto:chrup999@xxxxxxxxx]
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@xxxxxxxxxxxxx
 
www.enterasys.com


-----Original Message-----
From: Mitch Vincent [mailto:mvincent@xxxxxxxxxxxxxx]
Sent: Wednesday, August 08, 2001 6:10 PM
To: Hunter, Ray; pgsql-php@xxxxxxxxxxxxxx
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@xxxxxxxxxxxxx>
To: <pgsql-php@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
>
> www.enterasys.com
>

Attachment: dbConnect.class
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux