PostgreSQL + PHP 4.2x buggy with Apache?

Поиск
Список
Период
Сортировка
От jfo123@hotmail.com (Axier)
Тема PostgreSQL + PHP 4.2x buggy with Apache?
Дата
Msg-id ae3e57f6.0208060653.5a5c54b@posting.google.com
обсуждение исходный текст
Ответы Re: PostgreSQL + PHP 4.2x buggy with Apache?  (Richard Huxton <dev@archonet.com>)
Re: PostgreSQL + PHP 4.2x buggy with Apache?  (Ralph Graulich <maillist@shauny.de>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: nuno.barros@fc.ul.pt (Nuno Barros)
Дата:
Сообщение: View the contents of a database
Следующее
От: "Thomas Bolden"
Дата:
Сообщение: Cannot use more than 16 attributes in an index