Re: pgaccess use wrong password - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: pgaccess use wrong password
Date
Msg-id 200005311309.JAA28541@candle.pha.pa.us
Whole thread Raw
In response to pgaccess use wrong password  (Loïc TREGOUËT <loic@ext.cri74.org>)
List pgsql-admin
>        Excuse me for the latest message , i've found the solution
>
> local    all    password    passwdfile
>
> Now , passwords are stored (and crypted) in passwdfile .
> The authentication with psql is ok
>
> But pgaccess still use the password in clear in pg_shadow . Is there an
> option , i've not set correctly ?

I bet pgaccess is using tcp communications.  Try adding a 'host' line
too.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: "Wallingford, Ted"
Date:
Subject: create view security
Next
From: Loïc TREGOUËT
Date:
Subject: Re: pgaccess use wrong password