Using DbLink to access other PostgreSQL Databases and. Dblink.sql of your PostgreSQL install.To. Between our reporting postgres db and the. PostgreSQL Database Link to Oracle Database on. Monitoring approach for Streaming Replication with Hot Standby in PostgreSQL 9.3. Install and Configure Nagios for. Think Of Me Download Sheet Music Pdf more.

How to create database link between PostgreSQL 9.3 to Oracle XE 11 - (SQL/MED Management External Data - Foreign Data. Install PostgreSQL headers and. Downloads PostgreSQL Core Distribution. The core of the PostgreSQL object-relational database management system is. Based configuration and installation.

>I am a newbie so I may have done something wrong. I have made a database >link from Oracle 11.2 to Postgres 9.2 using unixODBC, Oracle HS and >Shivam Tamil Serial. psqlODBC. It is working fine. >>Now I want to do it the other way around, which is making a database >link from Postgres 9.2 to Oracle 11.2. I have figured out that I have to >install ODBC-Link 1.0.4 or Oracle_fdw 0.9.9. >From: >To:; >Subject: Re: [ODBC] Database link from Postgres to Oracle using ODBC >>On 11:59 PM, Bart Klein Ikink wrote: >>I am a newbie so I may have done something wrong. I have made a database >>link from Oracle 11.2 to Postgres 9.2 using unixODBC, Oracle HS and >>psqlODBC.

It is working fine. >>>>Now I want to do it the other way around, which is making a database >>link from Postgres 9.2 to Oracle 11.2. I have figured out that I have to >>install ODBC-Link 1.0.4 or Oracle_fdw 0.9.9.

>From: >To:; >Subject: Re: [ODBC] Database link from Postgres to Oracle using ODBC >>On 11:59 PM, Bart Klein Ikink wrote: >>I am a newbie so I may have done something wrong. I have made a database >>link from Oracle 11.2 to Postgres 9.2 using unixODBC, Oracle HS and >>psqlODBC. It is working fine. >>>>Now I want to do it the other way around, which is making a database >>link from Postgres 9.2 to Oracle 11.2. I have figured out that I have to >>install ODBC-Link 1.0.4 or Oracle_fdw 0.9.9.

>This is what I did: >- yum install gcc >- yum install postgresql92-devel-9.2.5 >- extract unixODBC-2.3.2.tar.gz (in /root/test) >- extract ODBC-Link-1.0.4.tar.gz (in /root/test) >- cd /root/test/unixODBC-2.3.2 >-./configure >- make >- make install >- cd. >- cd ODBC-Link-1.0.4 >- export PATH=$PATH:/root/test/unixODBC-2.3.2/include:/usr/pgsql-9.2/bin >- make USE_PGXS=1 >I am not sure what is going on. I can compile here. In my case I am using my distributions(OpenSUSE 12.2) package versions of unixODBC and unixODBC-devel You might try to do the same.

Note it is important that they be the same version for the same version of unixODBC. Then you could get rid of the export path=. -- Adrian Klaver -- Sent via pgsql-odbc mailing list () To make changes to your subscription. >From: >To:; >Subject: Re: [ODBC] Database link from Postgres to Oracle using ODBC >>On 11:50 PM, Bart Klein Ikink wrote: >>This is what I did: >>- yum install gcc >>- yum install postgresql92-devel-9.2.5 >>- extract unixODBC-2.3.2.tar.gz (in /root/test) >>- extract ODBC-Link-1.0.4.tar.gz (in /root/test) >>- cd /root/test/unixODBC-2.3.2 >>-./configure >>- make >>- make install >>- cd. >>- cd ODBC-Link-1.0.4 >>- export PATH=$PATH:/root/test/unixODBC-2.3.2/include:/usr/pgsql-9.2/bin >>- make USE_PGXS=1 >>>>Gts Fc-518ls Ethernet Driver Win7 here. I am not sure what is going on.

I can compile here. In my case I am >using my distributions(OpenSUSE 12.2) package versions of unixODBC and >unixODBC-devel >>You might try to do the same. Note it is important that they be the same >version for the same version of unixODBC. Then you could get rid of the >export path=. >>>-- >Adrian Klaver.

>I am a newbie so I may have done something wrong. I have made a database >link from Oracle 11.2 to Postgres 9.2 using unixODBC, Oracle HS and >psqlODBC.