Hi All,

How do I link a postgres server and an Oracle server and get the data from
an Oracle sever from a Postgres server? I'm using Postgres 7.2.3 on Red Hat
linux 7.2

Does postgres have any function to do so? And what other configuration
changes are need to achieve this?

Thanx All
Madhavi


Tue, 8 Jul 2003 12:03:42 +0530
"Madhavi Daroor" <madhavi@zoniac.com>
LinkServer
On 8 Jul 2003 at 12:03, Madhavi Daroor wrote:

> Hi All,
> 
> How do I link a postgres server and an Oracle server and get the data from
> an Oracle sever from a Postgres server? I'm using Postgres 7.2.3 on Red Hat
> linux 7.2
> 
> Does postgres have any function to do so? And what other configuration
> changes are need to achieve this?

Well no. There is nothing out of box that would help here.

You can try some approaches,

1. Dump oracle data in text format and load with copy.

2. Create a postgresql function in C which would also link against oracle 
client libraries, query the data and insert in postgresql database.

3. If writing a postgresql C function seems dounting to you, you can try a 
client application which links against both postgresql and oracle client 
libraries and transfer the data in between.

(1) is obvious. Other two might be a choice if you have special situation.

HTH

Bye
 Shridhar

--
We have found all life forms in the galaxy are capable of superiordevelopment.		
-- Kirk, "The Gamesters of Triskelion", stardate 3211.7


Tue, 08 Jul 2003 12:28:55 +0530
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Re: LinkServer
On Tuesday 08 Jul 2003 7:58 am, Shridhar Daithankar wrote:
> On 8 Jul 2003 at 12:03, Madhavi Daroor wrote:
> > Hi All,
> >
> > How do I link a postgres server and an Oracle server and get the data
> > from an Oracle sever from a Postgres server? I'm using Postgres 7.2.3 on
> > Red Hat linux 7.2
> >
> > Does postgres have any function to do so? And what other configuration
> > changes are need to achieve this?
>
> Well no. There is nothing out of box that would help here.

But I did see mention of a dblink for oracle a week or two ago. The dblink 
package is in contrib and I'd suggest a search of the archives for "dblink" 
and "oracle".

-- 
  Richard Huxton

Tue, 8 Jul 2003 09:03:35 +0100
Richard Huxton <dev@archonet.com>
Re: LinkServer

Here is someone looking for dblink with Oracle capability.  It is not in
CVS yet, but we are trying to get it for 7.4.  You might be able to run
/contrib/dblink from CVS in a few weeks without waiting for a 7.4 release.

---------------------------------------------------------------------------

Richard Huxton wrote:
> On Tuesday 08 Jul 2003 7:58 am, Shridhar Daithankar wrote:
> > On 8 Jul 2003 at 12:03, Madhavi Daroor wrote:
> > > Hi All,
> > >
> > > How do I link a postgres server and an Oracle server and get the data
> > > from an Oracle sever from a Postgres server? I'm using Postgres 7.2.3 on
> > > Red Hat linux 7.2
> > >
> > > Does postgres have any function to do so? And what other configuration
> > > changes are need to achieve this?
> >
> > Well no. There is nothing out of box that would help here.
> 
> But I did see mention of a dblink for oracle a week or two ago. The dblink 
> package is in contrib and I'd suggest a search of the archives for "dblink" 
> and "oracle".
> 
> -- 
>   Richard Huxton
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Mon, 21 Jul 2003 12:45:40 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: LinkServer