On Thu, Sep 1, 2011 at 7:48 AM, Campbell, Lance <lance@illinois.edu> wrote:
> Postgres 9.0.4
> I installed from the visual linux installer
> Redhat 6 newest updates
>
> I reinstalled postgres from scratch receintly. I recreated a role with
> createrole called XYZ. I do not want XYZ to use a password on my local
> box. How do I set this up so that it will not ask for a password?
two ways.
1: Set the pg server to just trust this user, connecting to x database
or all databases using the pg_hba.conf file
2: Set the normal md5 method in pg_hba.conf and use .pgpass file
(http://wiki.postgresql.org/wiki/Pgpass) to set a password for libpq
to use when that user logs into the db.