[Pgcluster-general] large objects replication

Benoit Mathieu benoit.mathieu at mist-technologies.com
Mon Jul 16 14:16:16 UTC 2007


Hi,

Thanks to Koen Martens and At.Mitani for your advices on my previous post.

I've juste succeed to set up pgcluster with a very simple configuration, 
2 clusterDB and 1 replication server, no load balancer for the moment, I 
just want to test large objects replication.

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.




More information about the Pgcluster-general mailing list