Re: dblink_connect fails

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