Re: Password when logging into postgres

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(dot)Bartolini(at)2ndQuadrant(dot)it - www.2ndQuadrant.it