Re: Client Authentication

Hi,

May be you should use the program

/usr/local/pgsql/bin/pg_passwd your_password_file

It will ask you to fill in names and passwds and make an encrypted file of it

Tuan

Gtrica wrote:
> 
> Hi all
> 
> I'm trying to configure Postgress to allow restricted access to database.
> I inserted in the file pg_hba.conf the following line:
> local   primo
> password   ./pass
> 
> the file pass in directory  "data" contains the line "giuseppe:gitrica"
> when I connect using "psql primo giuseppe" I'm asked to insert the password
> but it tells
> "Password authentication failed for user 'giuseppe' "
> 
> Giuseppe
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
  /\   /\          ___________________________________________________
 (  '''  )        |Les idées qui gouvernent le monde arrivent sur les |
  (@_ _@)         |pattes des pingouins ou sur les baskets des        |
 __( Y )__        |diablotins ou à dos de Gnou (Nietzche modifié)     |
(;;)>^<(;;)       |___________________________________________________|
===\[_]/===
 ¤-((_))-¤                           --------------------