pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedproblem largeobject
2+ messages / 2 participants
[nested] [flat]
* problem largeobject
@ 2000-09-25 14:39 Manika dey <bithi@plasma.ernet.in>
0 siblings, 1 reply; 2+ messages in thread
From: Manika dey @ 2000-09-25 14:39 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: pgsql-interfaces
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
-------------------------------------------------------------------
From:- |
Ms. Manika Dey. |Ph.No:--
Engineer-SC (Comp. Tech.) | IPR -- 02712 - 69276
I.P.R | EXT 336,315
BHAT, GANDHINAGAR | Residence -- 079 - 6619967
Gujrat -- 382 428 |
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: problem largeobject
@ 2000-09-25 22:44 Igor Gavriloff <igor@nupes.cefetpr.br>
parent: Manika dey <bithi@plasma.ernet.in>
0 siblings, 0 replies; 2+ messages in thread
From: Igor Gavriloff @ 2000-09-25 22:44 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-09-25 22:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-25 14:39 problem largeobject Manika dey <bithi@plasma.ernet.in>
2000-09-25 22:44 ` Igor Gavriloff <igor@nupes.cefetpr.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox