Re: Replication & BLOBs

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 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL