| From: | Garry Chen <gc92(at)cornell(dot)edu> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | dblink extension to Oracle is it passable |
| Date: | 2017-09-22 19:45:55 |
| Message-ID: | ECA1748F-169C-4256-94FD-D9CBB4724658@cornell.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi All,
Is dblink extension can connect to an Oracle instance? My stapes as following.
1. Create extension dblink
2. CREATE SERVER myserviec FOREIGN DATA WRAPPER dblink_fdw OPTIONS (host 'hostname', dbname 'dbname', port '1521');
3. CREATE USER MAPPING FOR dmtools SERVER myservice OPTIONS (user 'gc92', password 'mypasswd');
4. 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-09-22 20:00:24 | Re: dblink extension to Oracle is it passable |
| Previous Message | Garry Chen | 2017-09-22 12:59:33 | Re: Re: using LDAP for connection information lookup to do remote database connection |