Re: Trying to connect to an Oracle instance...

On Thu, Jul 13, 2006 at 05:46:55AM -0700, Spendius wrote:
> I've been trying to perform a connection to an Oracle DB for a while,
> to no avail. Here is what I get at my psql prompt:
> postdb=# Select dblink_connect('login','hostaddr=<host IP> port=1521 \
> dbname=orasid user=mylogin password=mypwd');
> ERROR:  could not establish connection
> DETAIL:  server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.

The contrib/dblink module is for connecting to other PostgreSQL
databases, not to Oracle or any other DBMS.  To connect to a non-
PostgreSQL database you could write a function in a server-side
language like PL/Perl and make the connection with DBI.  See also
DBI-Link:

http://pgfoundry.org/projects/dbi-link/

If the backend crashed then dblink might have a bug.  Can anybody
repeat this crash and get a stack trace?  I tried connecting to
MySQL and got a clean failure with the message "ERROR:  could not
establish connection".

--
Michael Fuhr