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é) |
(;;)>^<(;;) |___________________________________________________|
===\[_]/===
¤-((_))-¤ --------------------