| 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: | Whole Thread | Raw Message | 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) |