Re: pg_connect vs. pg_pconnect

"Hunter, Ray" <rhunter@xxxxxxxxxxxxx> · Thu, 9 Aug 2001 09:30:47 -0400

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 ----- 
  From: 
  Hunter, 
  Ray 
  To: 'Chris Ruprecht' 
  Cc: Pgsql-php (E-mail) 
  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 ----- 
    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@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)