Re: BUG #5457: dblink_connect now restricts non-superusers to password

Chana Slutzkin wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5457
> Logged by: Chana Slutzkin
> Email address: chana(at)cs(dot)huji(dot)ac(dot)il
> PostgreSQL version: 8.4
> Operating system: FreeBSD 7.2
> Description: dblink_connect now restricts non-superusers to password
> Details:
>
> dblink in version 8.4 forces a non-superuser to connect using a password.
> I would prefer to use ident.

I don't think ident is a good idea because the connection is coming from
the database server, not the client. The database server is always
going to be user 'postgres'. However, I assume pg_hba.conf could allow
you do make this work somehow, but with little security.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com