On 02/06/2014 06:07 PM, Reece Hart wrote:
> I'd like to provide public access, without a password, to a database
> hosted on Amazon RDS.
>
> I'm familiar with using pg_hba.conf to enable trust (no)
> authentication for a user. pg_hba.conf is not available to DBAs on RDS.
>
> Is there any other way to achieve password-less login in postgresql? I
> tried alter user password NULL.
>
Ignoring the scary security issues....
If you can't access pg_hba.conf how about just sticking pgbouncer or
similar in the middle and have your users connect through that?
Cheers,
Steve