Re: BUG #5583: dblink connection error

On 07/30/2010 07:04 AM, Piergiorgio Buongiovanni wrote:
> we obtain the following error:
>
> ERROR: password is required
> DETAIL: Non-superuser cannot connect if the server does not request a
> password.
> HINT: Target server's authentication method must be changed.
>
>
> ********** Errore **********
>
> ERROR: password is required
> Stato SQL: 2F003
> Dettaglio: Non-superuser cannot connect if the server does not request a
> password.
> Suggerimento: Target server's authentication method must be changed.
>
> Could you explain how to solve this problem?

This is *not* a bug -- please post to the correct list next time.

> HINT: Target server's authentication method must be changed.

Please see:
http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-conf.html

Specifically, as suggested by the hint:
auth-method

Also read:
http://www.postgresql.org/docs/8.4/interactive/contrib-dblink-connect.html

-and-

http://www.postgresql.org/docs/8.4/interactive/contrib-dblink-connect-u.html

HTH,

Joe

--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support