Thread: [NOVICE] dblink extension to Oracle is it passable
Hi All,
Is dblink extension can connect to an Oracle instance? My stapes as following.
- Create extension dblink
- CREATE SERVER myserviec FOREIGN DATA WRAPPER dblink_fdw OPTIONS (host 'hostname', dbname 'dbname', port '1521');
- CREATE USER MAPPING FOR dmtools SERVER myservice OPTIONS (user 'gc92', password 'mypasswd');
- SELECT dblink_connect('mydbink,'myservice');
Got follow error message:
ERROR: could not establish connection
DETAIL: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Thank you very much,
Garry
Hi All,
Is dblink extension can connect to an Oracle instance? My stapes as following.
From the docs:
"dblink is a module that supports connections to other PostgreSQL databases from within a database session."
You should investigate "Foreign Data Wrappers" (fdw) for connecting to non-PostgreSQL files/systems.
David J.
Oracle_fdw may help It is hosted on github -- Sent from: http://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice