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 : [email protected]
Unsubscribe : https://launchpad.net/~openerp-expert-framework
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~openerp-expert-framework
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-expert-framework
More help : https://help.launchpad.net/ListHelp
