pg_passwd queries - Mailing list pgsql-general

From Mark Jewiss
Subject pg_passwd queries
Date
Msg-id Pine.BSO.4.10.9912011407310.7277-100000@office.knowledge.com
Whole thread Raw
List pgsql-general
Hello,

I've looked over the list archives before, and didn't see anything about
this then....can't check now as I'm having problems getting on to the web
server :(

I'm using the pg_passwd script to create password files that are
referenced via the pg_hba.conf file. Each user has a different file
containing only their own password.

I've noticed that pg_passwd will encrypt any password given to it in lower
case only. Is this intentional, or a bug? To clarify, if a password is
entered and confirmed that has upper case characters in it, the password
that is encrypted contains lower case characters only.

Secondly, I want to build the password files as part of a script I have
written. I'm using the standard encrypt program on OpenBSD, but this does
not work - I get a user authentication error message each time I try to
log in. What method of encryption does the pg_passwd script use? I need to
be able to encrypt using DES or blowfish for this to work.

If anyone has any ideas or solutions that they have found please let me
know.

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com


pgsql-general by date:

Previous
From: "FM&NB"
Date:
Subject:
Next
From: Massimo Pichini
Date:
Subject: postgres libpq library