Skip site navigation (1) Skip section navigation (2)

Re: dblink_connect fails

From: Joe Conway <mail(at)joeconway(dot)com>
To: venkat j <venkatech(at)yahoo(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: dblink_connect fails
Date: 2003-12-19 19:10:29
Message-ID: 3FE34D25.5030604@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
venkat j wrote:
> .... perform dblink_connect(\'dbname=generic\'); .....
> 
> When i call this function, PostGreSql throws the following error:
> 
> ERROR:  dblink_connect: connection error: could not send startup
> packet: Transport endpoint is not connected

The error comes from libpq, or possibly from some other library (because 
I'm not seeing it anywhere in the libpq source). You might try adding
"hostaddr=127.0.0.1" to the connect string.

> But i tried out a sample function that works fine! This sample
> function works fine from psql prompt and from a java program. Can
> anybody help in understanding this error better?

Are you sure a database named "generic" exists? What *exactly* does the 
sample connect look like? Are you saying this works:
   select dblink_connect('dbname=template1');
but this doesn't:
   select dblink_connect('dbname=generic');
?

Joe



In response to

pgsql-cygwin by date

Next:From: shivaDate: 2003-12-20 06:59:03
Subject: Procedure Lang
Previous:From: Patrick SamsonDate: 2003-12-19 10:29:58
Subject: Postgres 7.3.X "make install" fails on pgtclsh

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group