On Thu, Sep 1, 2011 at 7:48 AM, Campbell, Lance <lance@xxxxxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
