[Pgcluster-general] large objects replication

[a.mitani at sra-europe.com]

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
>