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