From: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
To: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Password when logging into postgres
Date: Thu, 01 Sep 2011 15:54:34 +0200
Message-ID: <7f3d59de730b7a9be663deda073e5e05@2ndquadrant.it> (raw)
In-Reply-To: <B75CD08C73BD3543B97E4EF3964B7D70098260D8@CITESMBX2.ad.uillinois.edu>
References: <B75CD08C73BD3543B97E4EF3964B7D70098260D8@CITESMBX2.ad.uillinois.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Gabriele.Bartolini@2ndQuadrant.it, lance@illinois.edu
Subject: Re: Password when logging into postgres
In-Reply-To: <7f3d59de730b7a9be663deda073e5e05@2ndquadrant.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox