logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Re: dblink_connect fails: msg#00076

Subject: 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



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faqs/FAQ.html



<Prev in Thread] Current Thread [Next in Thread>