Replication Postgre > Oracle

On 07/08/13 20:24, BOUVARD Aur�lien 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,

100 terabytes?

Either way, not an insignificant amount of data!

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.BOUVARD@supinfo.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.

Hi,
From Oracle to PostgreSQL, you could have a look at Goldengate. It does not
support PostgreSQL as the source database.
Regards,
Jayadevan

On Wed, Aug 7, 2013 at 1:54 PM, BOUVARD Aurélien <
Aurelien.BOUVARD@supinfo.com> wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

...replication between PostgreSQL 9.2.4 and Oracle Database

...

We also thank to develop a solution based on trigger and/or WAL

Before you reinvent that first wheel, check out Bucardo, which is a
trigger-based solution that can go from Postgres to Oracle.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201308262157
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlIcB6AACgkQvJuQZxSWSshF+gCgkx7McL06gXAws96rzMSscsli
F9kAoIaTEJ1aZYxk8izDomL4ZtSjtMuO
=NavN
-----END PGP SIGNATURE-----

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general