Peter van der Meer <[EMAIL PROTECTED]> wrote:
> Hello everyone,
> 
> I seem to have a problem adding images to my PostgreSQL database with
> mmbase. I use PostgreSQL version 7.3.2 and the driver for jdk1.4 which is
> also the installed mmbase version (MMBase 1.6.5-Final.20030829). To store
> the image I use a bytea field, not an oid.
> 
> in the log, the following is listed before my mmbase crashes:


Postgresql and blobs in database are an hell. I advice to store blobs as
files.

This can be configured in postgresql.xml or so with a tag 'blobdatadir'.
<database>
  <name>PostgreSQL</name>
  ..
  <blobdatadir>../../data/vara</blobdatadir>

   ...


</database>


Michiel


-- 
Michiel Meeuwissen 
Mediapark C101 Hilversum  
+31 (0)35 6772979
nl_NL eo_XX en_US
mihxil'
 [] ()

Reply via email to