Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Chana Slutzkin <chana(at)cs(dot)huji(dot)ac(dot)il>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5457: dblink_connect now restricts non-superusers to password
Date: 2010-05-11 12:59:07
Message-ID: 201005111259.o4BCx7624935@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-05-11 14:52:01
Subject: Re: BUG #5458: Permission check is skipped by inheritance
Previous:From: Jasen BettsDate: 2010-05-11 09:24:55
Subject: Re: BUG #5457: dblink_connect now restricts non-superusers to password

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group