Tatsuo Ishii wrote:
pgpool(http://www2b.biglobe.ne.jp/~caco/pgpool/index-e.html) surely
can handle large objects. I don't know any other replication solutions
can handle them.
Mammoth Replicator can, but it is not open source.
Sincerely,
Joshua D. Drake
Be carefull, however, please make sure that the master and the slave
database clusters are physically synced before starting
replication. Also if multiple sessions are going to concurrently
create large objects, you need to make cluster wide explicite
concurrency controls. Otherwise OIDs may not become identical among
master/slave. To accomplish this, you can lock the shared table. For
example,
BEGIN;
LOCK TABLE pg_database;
creating large objec...
--
Tatsuo Ishii
Does anyone know of an open source single master- multi (or single) slave
replication system for Postgresql 7 or 8 which handles BLOBs?
Thanks,
Mark Childerson
Mark Childerson
espressoCode inc.
Ph: 416-963-8793
Fax: 416-963-8643
www.exdocs.com
www.espressocode.com
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
