Received: from aravis.cur-archamps.fr (aravis.cur-archamps.fr [195.202.0.99]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA86532 for ; Wed, 31 May 2000 05:53:30 -0400 (EDT) (envelope-from loic@ext.cri74.org) Received: from pc01.cri.cur-archamps.fr (pc01.cri.cur-archamps.fr [10.10.10.2]) by aravis.cur-archamps.fr (8.9.3/8.9.3) with ESMTP id LAA01753 for ; Wed, 31 May 2000 11:52:57 +0200 Received: from ext.cri74.org (localhost [127.0.0.1]) by pc01.cri.cur-archamps.fr (8.9.3/8.9.3) with ESMTP id LAA27666 for ; Wed, 31 May 2000 11:52:57 +0200 Message-ID: <3934E0F9.F8B13881@ext.cri74.org> Date: Wed, 31 May 2000 11:52:57 +0200 From: =?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686) X-Accept-Language: fr-FR, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pgaccess use wrong password Content-Type: multipart/alternative; boundary="------------4DEEB441D7DB68BF3AC38F0E" X-Archive-Number: 200005/52 --------------4DEEB441D7DB68BF3AC38F0E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 ? thanks loic@ext.cri74.org --------------4DEEB441D7DB68BF3AC38F0E Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit        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 ?
 

        thanks

                                                                                    loic@ext.cri74.org --------------4DEEB441D7DB68BF3AC38F0E--