Re: location of Large Object

Richard Emberson <emberson(at)phc(dot)net> writes:

> I would like to have all of the LargeObjects stored in a sub-directory
> which I
> could then make into a symbolic link.
>
> For example, have all of the LargeObjects stored in:
>
> ..../data/.../lo/
>
> I plan to have lots of large LargeObject (most of the data) and I'd like
>
> to have a means of controling thier storage (backup, adding more
> disks, etc.). Does such an option exist? If yes, then how? and if
> no, would I have to look at the contrib/lo/ code as the place to
> start?

As I understand it, large objects are stored in a regular table, which
has its own file or files in the database directory. You'd have to
manage these "by hand"--create a symlink for each file making up that
table, pointing to the real file on another disk. Kind of a hassle
and definitely error-prone.

Large objects are a native part of PG--the stuff in contrib/ is just
extra utilities.

In order to get what you want in any kind of clean way would require
source changes. There is support for "tablespaces/locations" in the
works, possibly for 7.3, that may help with this kind of thing in
future.

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...