From: | George(dot)T(dot)Essig(at)stls(dot)frb(dot)org |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL + PHP 4.2x buggy with Apache? |
Date: | 2002-08-06 19:11:47 |
Message-ID: | 20020806191553.22FFC4765EC@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In PHP, you might also want to add 'set_time_limit(0);' to make sure your
PHP script runs until completion.
George Essig
----- Forwarded by George T Essig/STLS/FRS on 08/06/02 02:06 PM -----
George T
Essig To: pgsql-general(at)postgresql(dot)org
cc:
08/06/02 Subject: Re: PostgreSQL + PHP 4.2x buggy with Apache?
01:46 PM
It sounds like you have a problem with the persistent PostgreSQL
connections used by PHP and Apache. Change pg_pconnect to pg_connect and
restart Apache to close the existing persistent connections. My experience
is that pg_pconnect is not as robust as pg_connect and not worth the
increase in speed.
George Essig
> After last night I cannot connect via the webinterface anylonger. The
> webserver still answers on requests and I can logon via psql or
> pgAdmin and issue commands there, but no way to connect via my
> PHP-script.
>
> the line that hangs is the pg_connect:
> $link = pg_pconnect("dbname=$Database user=$DbId password=$DbPassword
> host=localhost");
>
> $query = "COPY test FROM stdin;";
> $sth = pg_query ($link, $query);
>
> regards, Axier
From | Date | Subject | |
---|---|---|---|
Next Message | Ralph Graulich | 2002-08-06 19:15:25 | Re: URGENT: Database keeps crashing - suspect damaged RAM |
Previous Message | scott.marlowe | 2002-08-06 19:10:49 | Re: MySQL or Postgres ? |