Skip site navigation (1) Skip section navigation (2)

Re: problem largeobject

From: Igor Gavriloff <igor(at)nupes(dot)cefetpr(dot)br>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: problem largeobject
Date: 2000-09-25 22:44:19
Message-ID: 39CFD543.B1C7DA82@nupes.cefetpr.br (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

   You can transfer data to the server thru an fileupload field in your
forms, then the web server will make that file available at a temp
location to the cgi. I use PHP for my programs, for me it's quite simple
to track where are the files, probably there must be an specification in
the servlets api on how to deal with fileuploads. Here we have machines
running Solaris, Linux and Windows, and this kind of treatment is
working just fine in our tests (this implementation's platform
independent). Just watch out the configs around where it sets a max size
that can be uploaded (servers, cgis...).
   Just on remark: some OSs have a limitation in the max ammount of
files that can reside in one single directory: when it's reached it
starts to have an slower acces in that dir as more files are put into
it.
   The "lo" interface puts all the files into the /...../pgsql/data/base
directory, so, in a system with heavy use of large objects, (as mine's
going to be) it would degradate the performance of the backend. I'm also
running Solaris where I run the postgres backend and the web daemon
(Apache), and I've found no information on how much files I can put into
a single dir, but had the information (from a person that works here)
that Solaris has an maximum ammount of files per filesystem (thought he
couldn't tell me how much), so, the possibility of having an limit in a
single dir isn't discarted.
   Just for an example: Squid (an proxy server for the unix platform)
create several sub-dirs (and a couple more in each of them) in the main
cache dir to avoid system degradation. As I have noticed this in the few
days, I'm going to write my own code on how to deal with those files -
beside using the lo interface provided - before my system enters in a
production state. Another point it that it's hard to track an lo object
in a case of a system crash. Is it too much paranoya or not? Any
comments are welcome.

Igor.

Manika dey wrote:

> Hi,
>   i am at present working on postgresql6.3 on sun solaris2.5 i want help
>   for my  following problem :
>
>  * how can i  transfer data from window NT/window95 to the database
>   of postgresql6.3 on sun solaris2.5
>  * the above mentioned machines are all on the same network.
>  * i am using jdbc driver with jdk1.1.4 with servlet for my present
>    work.
>
>   i will be thankful if some one can suggest me a solution for this
>   as soon as possible.
>
>   with regards
>   manika
>

--
Anyone can make an omelet with eggs.  The trick is to make one with
none.


In response to

pgsql-interfaces by date

Next:From: Andreas VoglerDate: 2000-09-26 13:33:19
Subject: FastPath protocol error: Z
Previous:From: Manika deyDate: 2000-09-25 14:39:17
Subject: problem largeobject

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group