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?
Re: PostgreSQL + PHP 4.2x buggy with Apache? |
Список | 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 по дате отправления: