[Pgcluster-general] large objects replication

[Benoit Mathieu]

Koen Martens a écrit :
> Just curious, since i never got this to work:
>
> What happens when you access the large object with lo_open, and make modifications with lo_write? Are those replicated?? I never got that to work.
>
> Another problem I encountered was that if i pg_restore a db with large objects, replication of the large object fails (which is to be expected of course).
>
> These limitations made me abandon pgcluster for that particular project. I think for static large objects, it works fine. But when you modify the large objects in stream access mode (lo_read / lo_write), things go awry.
>
> Gr,
>
> Koen
>   

You're right. My first attempt didn't work because I was using directly 
lo_open and lo_write from the client. These operations were processed 
only on the clusterDB my client was connected to, and were not replicate 
on other clusterDB because I can't export my file from another clusterDB.

A.Mitani wrote that lo_write is supported by pg_cluster, but not 
lo_export. Does it means that lo_write operations are replicated but you 
can't export from other cluster ? strange ...

regards,

Benoit