Symmetric-ds it is a replication solution that handles large objects, it is
asynchronous and multi-master, i have been using between 30 separate postgresql
connected by a slow link and until now i have been working without problems, i
think this project should be in the wiki.
http://symmetricd
> > However you need to use newer API
> > of libpq to create large objects:
> >
> > Oid lo_create(PGconn *conn, Oid lobjId);
> [...]
> > You cannot use old API lo_creat() since it relies on OID, which
> > pgpool-II does not guarantee OIDs can be replicated.
>
> Does it mean that lo_create(conn,
Tatsuo Ishii wrote:
> However you need to use newer API
> of libpq to create large objects:
>
> Oid lo_create(PGconn *conn, Oid lobjId);
[...]
> You cannot use old API lo_creat() since it relies on OID, which
> pgpool-II does not guarantee OIDs can be replicated.
Does it mean that lo_cr
On Dec 2, 2009, at 5:48 PM, Tatsuo Ishii wrote:
> BTW
>
>> Additionally there is a list of available open-source replication solutions
>> here:
>> http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling
>
> The link http://www.slony2.org/ mentioned in the wiki page
BTW
> Additionally there is a list of available open-source replication solutions
> here:
> http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling
The link http://www.slony2.org/ mentioned in the wiki page above
apparently does nothing to do with Slony-II. Can someon
> Does anyone know of a replication solution that can handle large
> objects? Preferrably on a per database rather than per cluster basis.
pgpool-II can handle large objects. However you need to use newer API
of libpq to create large objects:
Oid lo_create(PGconn *conn, Oid lobjId);
I'm not sur
On Dec 2, 2009, at 4:23 PM, Howard Cole wrote:
> Does anyone know of a replication solution that can handle large objects?
> Preferrably on a per database rather than per cluster basis.
Take a look at Mammoth Replicator:
https://projects.commandprompt.com/public/replicator.
Additionally there
Does anyone know of a replication solution that can handle large
objects? Preferrably on a per database rather than per cluster basis.
Incidentally - out of interest - why doesn't Slony handle large objects?
Thanks.
Howard
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-genera
