| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Password when logging into postgres |
| Date: | 2011-09-01 13:52:47 |
| Message-ID: | CAOR=d=1oJKgP1o8rDGYNMpe8NHNU1M6M+cOrixF0ZpcX-yZTzA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Sep 1, 2011 at 7:48 AM, Campbell, Lance <lance(at)illinois(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gabriele Bartolini | 2011-09-01 13:54:34 | Re: Password when logging into postgres |
| Previous Message | Tom Lane | 2011-09-01 13:52:34 | Re: Schema with OID 0 does not exist in pg_dump |