Re: Copy_from gets stuck with bigger input file
paftek <[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Message-ID | <[email protected]> |
On 10/29/08, paftek <[email protected]> wrote: > Any news about this issue ? > > I bypassed it in my application by only sending few rows through > copy_from() at a time. > > But today I believe that I encounter the same issue using psycopg2 with > Londiste from Skytools 2.1.8. > Same symptom : a COPY get stuck, no CPU usage, even on small tables. > I tried psycopg2 v2.0.5.1 and v2.0.8 (Debian v4.0 OS up-to-date). > > I switched back temporarily to psycopg1 v1.1.21 and it works perfectly. > > I will try to get feedback from Skytools mailing list too. There is a > similar case here : > http://pgfoundry.org/pipermail/skytools-users/2008-July/000660.html > I have just found a workaround thanks to the Skytools mailing list : setting the postgresql.conf ssl parameter from true (default) to false. Could it help to fix the issue ?