| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Sameer Kumar *EXTERN*" <sameer(dot)kumar(at)ashnik(dot)com>, Serge Fonville <serge(dot)fonville(at)gmail(dot)com> |
| Cc: | Geoff Montee <geoff(dot)montee(at)gmail(dot)com>, PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Oracle to PostgreSQL replication |
| Date: | 2014-05-09 13:24:44 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17CF8054@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sameer Kumar wrote:
> I guess I will be exploring more on oracle foreign data wrapper.
>
> Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would it handle failovers.
I have not tried it, but it should work as follows:
- You'll have to use a connect string that is correctly defined for
"transparent application failover", see
http://docs.oracle.com/cd/E11882_01/network.112/e10836/advcfg.htm#NETAG455
- Failover will happen automatically.
- SELECTs should be able to complete without error message.
- INSERT, UPDATE and DELETE will fail with an error message and
will have to be retried. I did not code oracle_fdw to support
TAF for DML statements.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-05-09 13:52:33 | Re: Receiving many more rows than expected |
| Previous Message | Vincent de Phily | 2014-05-09 12:36:36 | Re: Receiving many more rows than expected |