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
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 |