Thanks for answering!
My problem is that the Oracle Db and the PostgreSQL Db are both on
different servers, and I;ve been told by Oracle support that I need to
install the PostgreSQL driver in my Oracle server. Now I don't know how
to solve the PG_CONFIG error, as there's no pg_config file in the Oracle
server!
How can I solve this?
Thanks a lot!
Daniela.
Craig Ringer escribió:
> On 2/12/2009 4:03 AM, Daniela Mamede d'Almeida wrote:
>> Hi!
>> I'm trying to connect an Oracle Db with a PostgreSQL Db, by means of
>> Oracle heterogeneous service.
>> I've installed (in my oracle server) DG4ODBC which is the oracle
>> gateway, UnixODBC which is the driver manager... and all I need now is
>> the PostgreSQL driver. I've downloaded psqlodbc... but I can't
>> "configure" it as it says that theres a missing variable ...
>> "PG_CONFIG".
>
> Possible hints:
>
> http://www.google.com.au/search?q="PG_CONFIG"+"unixodbc"
>
> Particularly:
>
> http://cpansearch.perl.org/src/RKIES/UnixODBC-0.34/dbms/README
>
> ... which suggests that you must specify PG_CONFIG as an environment
> variable when calling configure:
>
> # export PG_CONFIG=/usr/local/pgsql/bin/pg_config
> # ./configure
>
> (adjust PG_CONFIG for the location of pg_config on your system).
>
> --
> Craig Ringer