[Pgcluster-general] large objects replication

[Benoit Mathieu]

OK.

If I import large objects from a shared directory, everything goes well, 
and large objects are available from any cluster DB.

thanks !

benoit mathieu

a.mitani at sra-europe.com a écrit :
> Hi,
>
> PGCluster is replicating the file path of large object during each cluster
> DB.
> Therefore, the target file should to be able to access with same file path
> from each cluster DB.
> I recommend to use file server in order to store target large object
> files, and share it during each cluster DB.
>
> Regards,
> ------------
> At.Mitani
>
>   
>> Replication works when I create database, table, insert element.
>> I've imported my file (file1) on cluster1 via the lo_import API of libpq
>> C client library. It succeed, and I can export my file from cluster1,
>> but I can't export my file from cluster2. I seems that large object
>> hasn't been replicated ...
>>
>> On some old post in mailing-list I found that replication of large
>> objects works since pgcluster 1.3, but only if files are stored on a
>> shared filesystem. I can't find anything about setting a particular path
>> to store large object in postgres. I've watched for differences in
>> $PG_DATA between cluster1 and cluster2. The only difference is in
>> directory $PG_DATA/pg_xlog
>>
>> Does someone have any idea on which directory to share between
>> clusterDBs to manage large objects replication ? or any other advice to
>> deal with this ?
>>
>> best regards,
>>
>> Benoit M.
>>
>>
>> _______________________________________________
>> Pgcluster-general mailing list
>> Pgcluster-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>>
>>     
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
>
>