From: | Geoff Russell <geoff(at)austrics(dot)com(dot)au> |
---|---|
To: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | Large Objects Across a Network |
Date: | 2000-09-17 23:56:04 |
Message-ID: | Pine.GSO.4.05.10009180923010.7344-100000@magnum |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I've been experimenting with large objects - I don't need Gb, but
(usually) around 10k to 30k per object. It seems that the files in the
lo_import/lo_export calls have to be on the same machine as the backend
and furthermore that they can't contain symbolic links.
Am I right so far?
If so, then how does a person on a second machine get a large object.
e.g., I'm working on machine MYHOST, and the backend is on OTHERHOST.
$ export PGHOST=OTHERHOST
$ psql DB
db=# select lo_export(T.X,'/tmp/X') from T where ...
will give you a file on OTHERHOST so I need to make sure MYHOST can
see the file.
Is there a way of having a network client use large objects without requiring
NFS or similar to share disks?
Cheers,
Geoff Russell
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Fifth Ave +618-8332-5069 (Home) |
St Morris SA 5068 +618-8207-2029 (Work) | geoff(at)austrics(dot)com(dot)au
Adelaide, AUSTRALIA +618-8364-1543 (Fax-Home) |
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Kientzle | 2000-09-18 01:13:49 | Re: LOCK TABLE |
Previous Message | John Draper | 2000-09-17 21:43:31 | Re: How do I add a column to an existing table. |