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
[email protected] - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
