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