Re: encrypted passwords - Mailing list pgsql-general

From jseymour@linxnet.com (Jim Seymour)
Subject Re: encrypted passwords
Date
Msg-id 20040608104347.7D60E430E@jimsun.linxnet.com
Whole thread Raw
In response to encrypted passwords  (Milos Prudek <prudek@bvx.cz>)
Responses Re: encrypted passwords  (<btober@computer.org>)
Re: encrypted passwords  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
>
> I cannot set up password authentication with encrypted passwords. With
> plaintext passwords auth works fine. So my guess is that I am using an
> incorrect password encryption program.
>
> What encryption utility should I use to store an MD5 password?
>
> I tried md5sum, but passwords encrypted with md5sum will not let me log in.
>
> I also tried classic "crypt", and I used Python's crypt module to
> encrypt my password, and it did not work either.

You don't manually encrypt them with anything.  You enter them
plain-text and pgsql encrypts them before storage.

Jim

pgsql-general by date:

Previous
From: Michael Kleiser
Date:
Subject: When to use postgreSQL , when to use other
Next
From: mike
Date:
Subject: problem with inserting a generated seq no into not null field