Skip site navigation (1) Skip section navigation (2)

Re: Client Authentication

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

In response to

pgsql-admin by date

Next:From: Brian McCaneDate: 2002-02-22 19:10:43
Subject: Strange locking behaviour
Previous:From: Naomi WalkerDate: 2002-02-22 18:46:44
Subject: Backup and Recovery (revisited)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group