PostgreSQL + PHP 4.2x buggy with Apache?

From: jfo123(at)hotmail(dot)com (Axier)
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL + PHP 4.2x buggy with Apache?
Date: 2002-08-06 14:53:19
Message-ID: ae3e57f6.0208060653.5a5c54b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

anyone that could help me out would do me a great favour.

I ran in to this problem yesterday.
Issue: I am trying to import a huge table into pgsql using "Copy
from".
I do it like this: Simple html-interface, opening txt-files
and then I use copy to perform a high-speed insert.

The environment used from the beginning was Apache 2.0.39 + PHP 4.2.2
+ PostgreSQL 7.2 under Cygwin.

After a while I noticed that the webserver stopped responding so I
downgraded to 1.3.26 and now everything started to jump fairly well,
until yesterday night.

I had just processed a test file of 200 000 records. (I issue an "end
copy" command every 1000 lines in some sort of "Commit".
Commit example:
pg_put_line($link, "\\.\n");
pg_end_copy($link);
$query = "COPY test FROM stdin;";
$sth = pg_query ($link, $query);

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J Smith 2002-08-06 14:56:30 Re: Creating GiST Indices?
Previous Message Tom Lane 2002-08-06 13:55:45 Re: Return num of deleted rows from function