Postgres Plus Advanced Server (PPAS) is a licensed version of PostgreSQL owned by EnterpriseDB. You need to buy a support contract to use this software (although there is a 45 day trial period).
The component you are talking about is xDB Replication Server, which is part of the PPAS product or can be licensed separately for use with community versions of PostgreSQL.
xDB Replication server is trigger based (on both the Oracle and the PostgreSQL side). It can handle asynchronous master/slave or multi-master replication.
You can ask more questions about xDB at the EDB forums over at http://forums.enterprisedb.com/forums/list.page or contact EDB directly for pre-sales advice.
Cheers,
James Sewell
PostgreSQL Team Lead / Solutions Architect
_____________________________________
PostgreSQL Team Lead / Solutions Architect
_____________________________________
On Wed, Aug 7, 2013 at 6:24 PM, BOUVARD Aurélien <Aurelien.BOUVARD@xxxxxxxxxxx> wrote:
Hi all,
My compagny would like to configure replication between PostgreSQL 9.2.4 and Oracle Database (11g and maybe 12c soon). We saw that Postgres Plus Database Replication could be a good solution for us.
We also thank to develop a solution based on trigger and/or WAL , but we didn’t know if it’s possible in our case…we have a huge amount of data (100 terabits) and it will increase soon (Datawarehouse context)
So it will be very interesting for us to have some feedback about PostGre Plus or other concepts/solutions.
Regards,
The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.
