Re: Accessing other databases with DBLink when leaving user/password empty

Hi Adrian,

I tried what you suggested, but still get the following Error:
"Error connecting to the server: fe_sendauth: no password supplied"

What is it I'm doing wrong? Isn't it possible to leave the password
empty so that PostgreSQL can retrieve it from the current account?

Thank you.

Adrian Klaver wrote:
> On Friday 06 June 2008 2:32 am, Hermann Muster wrote:
>> Does no one have any idea about that?
>>
>> Regards.
>>
>> Hermann Muster wrote:
>>> Hi,
>>>
>>> I have the following problem when trying to access other PostgreSQL
>>> databases with DBLink. I followed the instructions on
>>> http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink
>>> -to-access-other-PostgreSQL-Databases-and-Servers.html.
>>>
>>>
>>> My query to get access to another database on the same server looks like
>>> this:
>>>
>>> select dblink_connect('1512','host=127.0.0.1 port=5432
>>> dbname=Test user=postgres password=postgres');
>
> From the documentation:
> http://www.postgresql.org/docs/current/static/dblink.html
> Don't do the above.
>
>
>>> select * from dblink('1512','select "Vorname", "Name" from
>>> "PERSONEN"')
>>> AS (Vorname text, Name text);
>
> Here do:
> select * from dblink('dbname=Test','select "Vorname", "Name" from
> "PERSONEN"')
> AS (Vorname text, Name text);
>
>>> The question is if it is possible to leave the 'user' and 'password'
>>> empty, so that these are taken from the account I'm currently using, as
>>> described below (taken from the above article).
>>>
>>> [...]
>>> Below is an example of querying a database on the same server
>>> and cluster using DbLink. Note if no username and password is
>>> specified, then DbLink connects with whatever account you are
>>> currently using.
>>>
>>> It is not possible to connect to the other database when they are empty
>>> and it seems that DBLink can't get them from the currently used account.
>>> Can you please help me with that? Thank you.
>>>
>>> Regards,
>>> H. Muster
>