Thread: Password when logging into postgres

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.

 Hi Lance,

>  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?

 You have two options:

 1) insert a line in ~/.pgpass file in your home directory for that
 database user
 (http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html)
 2) insert a 'trust' rule for that user in the pg_hba.conf for local
 connections
 (http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html)

 I would personally go with #1 in production environment.

 Cheers,
 Gabriele

--
  Gabriele Bartolini - 2ndQuadrant Italia
  PostgreSQL Training, Services and Support
  Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it