On Fri, Oct 01, 2004 at 07:33:29PM +0200, Ryszard Lach wrote:
> Let's say, that in database are stored fragments of some kind of text
> files used to generate html. They contain links to other files, which
> are binary (.doc,.xls, multimedia files etc.) files uploaded by users
> editing application content. The may be too big to store them in
> database, besides slony doesn't support blobs. 

Ok, I see.  Someone will correct me if I'm wrong, but I think slony
will do bytea.  It doesn't do the lo stuff, though.  In any case, I
suspect that slony is the wrong tool for you.

What you really want is event-dependent syncing of the nodes, and for
that, you need to replicate if and only if you have the right version
of the files.  I think something based around what Robert Kaye is
doing to dbmirror would probably help you.  The file for that is
supposed to be at
http://conferences.oreillynet.com/cs/os2004/view/e_sess/5480, but I
get a 403 when I follow the link.  Anyway, you can probably find
Robert through MusicBrainz.  

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.
		--J.D. Baldwin