Manuel Garc?a wrote:

> Hi, I need some advices, maybe somebody can help me. I need to
> replicate some tables that are in different servers, all that servers
> using PostgreSql 7.3 , I need consolidate all information inside many
> tables that are allocated on Oracle, but I need to apply only the
> changes because If I insert all the information my process take around
> 3 or more hours. Then I need to consolidate all the information
> applying only the movements that I don?t apply yet.
>
> Somebody can tell me if I can use the slony1 to do that? and what is
> the level of confidence using this mechanism to assure the integrity
> of my information?
>
> Thanks in advanced.
>
Slony-I is designed for use with PostgreSQL; there has not been any
particular thought put into making it able to support Oracle.

If you were prepared to do a LOT of hacking around with the code in
slon, it would quite likely be possible to come up with something that
could write data into an Oracle database. This would require that you
get to know the code of slon well enough that you would have little need
to ask questions on this mailing list!

Version 1.1 (coming Real Soon Now(tm)) has a "log shipping" facility
that might make the task of writing data into an Oracle database involve
a lot less "surgery." With "log shipping," the updates are all
serialized into files on disk, and are Plain Ordinary Queries. They
become plain INSERT, UPDATE, and DELETE statements.

You would likely need to modify the header/footer of each log file, but
that should be a pretty easy task using any old scripting language.

But that's also assuming that the operating model of Slony-I is
consistent with how you need data to be replicated...
-- 
<http://linuxdatabases.info/info/slony.info>