[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