Re: Can not input large text data

From: qk22(at)gmx(dot)co(dot)uk (qk22)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can not input large text data
Date: 2001-10-26 14:04:45
Message-ID: ddcf3d6.0110260604.7f959349@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

johnny(at)halfahead(dot)dk (=?ISO-8859-1?Q?=22Johnny_J=F8rgensen=22?=) wrote in message news:<200110242321330793(dot)0215978B(at)mail(dot)halfahead(dot)dk>...

> That sounds very much like the POST maximum file size, set in php.ini. try phpinfo(), and see what your size is, the default is somewhere pretty near 7MB

>

> *********** REPLY SEPARATOR ***********

>

> On 24-10-2001 at 07:23 qk22(at)gmx(dot)co(dot)uk wrote:

>

> >postgresql(at)envisity(dot)com ("Aasmund Midttun Godal") wrote in message

> >news:<20011024001923(dot)22212(dot)qmail(at)ns(dot)krot(dot)org>...

> >> Maybe this is a problem - take a look at your watch. See how long time

> it takes. then check out httpd.conf look for timeout (probably 300 secs).

> >>

> >> Reagards,

> >>

> >> Aasmund

> >>

> >> On 20 Oct 2001 11:25:19 -0700, qk22(at)gmx(dot)co(dot)uk (qk22) wrote:

> >> > tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote in message

> news:<25124(dot)1003431283(at)sss(dot)pgh(dot)pa(dot)us>...

> >> >

> >> > I am using phpPgAdmin2.3--(apache+php+pgsql) as the form interface to

> >> > input data within Netscape Navigator, in fact the text fields can

> >> > input data very well exceed the 8k and 32k limits. The problem is that

> >> > you still can not input data with fairly large size such as 7MB or

> >> > above, and I don't know if there is anything wrong with the database.

> >> >

> >> > ---------------------------(end of

> broadcast)---------------------------

> >> > TIP 5: Have you checked our extensive FAQ?

> >> >

> >> > http://www.postgresql.org/users-lounge/docs/faq.html

> >>

> >> Aasmund Midttun Godal

> >>

> >> aasmund(at)godal(dot)com - http://www.godal.com/

> >> +47 40 45 20 46

> >>

> >> ---------------------------(end of broadcast)---------------------------

> >> TIP 3: if posting/reading through Usenet, please send an appropriate

> >> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your

> >> message can get through to the mailing list cleanly

> >

> >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

>

>

> Mvh,

>

> Johnny Jørgensen

>

> johnny(at)halfahead(dot)dk

> +45 6315 7328

>

>

> ---------------------------(end of broadcast)---------------------------

> TIP 4: Don't 'kill -9' the postmaster

You are right! I checked and realized the line "post_max_size 8M " in
"phpinfo.php" test page, so I changed the "post_max_size" to 800M in
"php.ini" and "Timeout" value to 3000 in httpd.conf. Then everything
is ok now. So that was the Apache and PHP configuration problem.
Thank you for all.

Best regards

qk22

In response to

Browse pgsql-general by date

  From Date Subject
Next Message CJ Kucera 2001-10-26 14:10:24 Database-level permissions?
Previous Message Roderick A. Anderson 2001-10-26 12:18:28 Re: RESOLVED : Re: sql script questions