Re: Replication Postgre > Oracle

From: James Sewell <james(dot)sewell(at)lisasoft(dot)com>
To: BOUVARD Aurélien <Aurelien(dot)BOUVARD(at)supinfo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Replication Postgre > Oracle
Date: 2013-08-07 08:59:17
Message-ID: CANkGpBvXK9rFOtZh1-F2oE5CWv7K7p_xf26ECcG=41kQ8OUtsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
_____________________________________

[image:
http://www.lisasoft.com/sites/lisasoft/files/u1/2013hieghtslogan_0.png]

Level 2, 50 Queen St,
Melbourne, VIC, 3000

P: 03 8370 8000 F: 03 8370 8099 W: www.lisasoft.com

On Wed, Aug 7, 2013 at 6:24 PM, BOUVARD Aurélien <
Aurelien(dot)BOUVARD(at)supinfo(dot)com> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vishalakshi Navaneethakrishnan 2013-08-07 09:46:54 How to avoid Force Autovacuum
Previous Message Gavin Flower 2013-08-07 08:44:34 Re: Replication Postgre > Oracle