From: | tuan <tuan(dot)nguyen(at)freesbee(dot)fr> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Client Authentication |
Date: | 2002-02-22 18:54:45 |
Message-ID: | 3C7693F5.6B309022@freesbee.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)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é) |
(;;)>^<(;;) |___________________________________________________|
===\[_]/===
¤-((_))-¤ --------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Brian McCane | 2002-02-22 19:10:43 | Strange locking behaviour |
Previous Message | Naomi Walker | 2002-02-22 18:46:44 | Backup and Recovery (revisited) |