Обсуждение: Replication Postgre > Oracle
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?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,
Either way, not an insignificant amount of data!
James Sewell
PostgreSQL Team Lead / Solutions Architect
_____________________________________
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 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,
-----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-----