Re: Can not input large text data

From: "Aasmund Midttun Godal" <postgresql(at)envisity(dot)com>
To: qk22(at)gmx(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can not input large text data
Date: 2001-10-24 22:38:28
Message-ID: 20011024223828.21669.qmail@ns.krot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well did you wait 300 secs or did it come immediately? because if you did then it is the webserver that cuts the connection because you have surpassed the timeout. Simply increasing the 300 value may work. however some browsers have a timeout on their side too.

I believe that the problem is probably caused by something other than postgres, (it may be any number of things) just try swapping around a lot of different things and settings - try storing the file to disk instead - does that work? try reading the post input directly and see if it is all there? if it comes immediately - has it already transferred the 7 mb? try setting boobie-traps in your script - what is the size of the actual post? have you remembered to set the appropriate enctype in the form ('multipart/form-data') there are simply too many things that can cause this. Try to narrow the problem down - and if it turns out to be postgres, then I do not know what the problem might be - somebody else here might though. I just uploaded a 10mb file through http into postgres - no problem.
On 24 Oct 2001 07:23:59 -0700, qk22(at)gmx(dot)co(dot)uk (qk22) wrote:
> postgresql(at)envisity(dot)com ("Aasmund Midttun Godal") wrote in message news:<20011024001923(dot)22212(dot)qmail(at)ns(dot)krot(dot)org>...
>
> I checked httpd.conf and found the "timeout" setting is 300, I tried
> again and the error message in netscape appears immediately as
> following:
> ______________________________________
> A network error occurred while netscape
> was sending data.
> (Network Error: Connection reset by peer)
>
> Try connection again
> ______________________________________
> I want to know if there are some configuration changes that can be
> made in order to enable the input of large text data though web
> server.
>
> Thank you
>
> qk22
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

Aasmund Midttun Godal

aasmund(at)godal(dot)com - http://www.godal.com/
+47 40 45 20 46

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aasmund Midttun Godal 2001-10-24 22:41:11 Re: Record
Previous Message Stephan Szabo 2001-10-24 22:08:34 Re: Function won't compile