openerp-expert-framework team mailing list archive

[Cloves Almeida <cjalmeida@xxxxxxxxx>]

Yes you can. That's database replication. You can do it at PG level with 
a number of tools. Check this page:

http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

What I proposed was a more generic integration strategy. When all you 
want is to scale, replication is fine. When your environment is not 
homogeneous (inter-company instances, or when integrating with different 
applications), eventually you'll have to parse the data to suit your 
needs and messing with SQL logs is a PITA.

One example is the PO/SO integration. You need to parse the incoming 
"Sales Order" message to construct a "Purchase Order". For such use 
case, SQL log transfer is not the way to go.


P. Christeas escreveu:
> On Monday 22 February 2010, you wrote:
>   
> > You are now subscribed to the blueprint replay-from-dump - register
> > in/ou messages/SQL and be able to replay it from dump.
> >
> >     
> Couldn't we use Postgresql's logging capabilities (it can log all queries) + a 
> debug-level log of the openerp server?
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-expert-framework
> Post to     : openerp-expert-framework@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-expert-framework
> More help   : https://help.launchpad.net/ListHelp
>