Re: [GENERAL] Large Object questions...

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: "John Huttley" <john(at)mwk(dot)co(dot)nz>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Large Object questions...
Date: 1999-08-01 13:26:55
Message-ID: l03130302b3c9f712a94d@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 08:31 +0300 on 30/07/1999, John Huttley wrote:

> I'm busy writing a faxserver application where all the fax page data is
> stored as a blob.
>
> Its just so easy to use...

How will you be backing it up? pg_dump never dumped large objects.

IMO, if you need a specialized backup script, plus a non-standard interface
for writing into them and reading from them, and they are not deleted when
you drop the row referring to them, then you may as well use files, and
store only the path in Postgres for easy lookup.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1999-08-01 14:31:07 Re: [GENERAL] Search
Previous Message astromonk 1999-08-01 13:02:56 Where is DBD-pg.92RPMS? (.91 not compat with postgres?)