Re: db security (md5) - Mailing list pgsql-general

From jseymour@LinxNet.com (Jim Seymour)
Subject Re: db security (md5)
Date
Msg-id 20040419205354.A03DC4307@jimsun.LinxNet.com
Whole thread Raw
In response to db security (md5)  ("Sally Sally" <dedeb17@hotmail.com>)
List pgsql-general
"Sally Sally" <dedeb17@hotmail.com> wrote:
>
> I wanted to use md5 authentication method for my pg db. I was initially
> using a trust method and I noticed when I switched to md5 I had to assign a
> password to the user postgres as it was created without one. Here do I pass
> an md5 encrypted string?

No.  md5 just refers to the way it's stored in pgsql.

>                          Also everytime I connect via perl's DBI do I have
> to pass it the encrypted string (if so which perl module for md5 encryption
> is the best to use?)

See above.

> I was confused as to whether I should create the password encrypted or
> whether postgres saves it encrypted.

The latter.

Jim

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Data Encryption in PostgreSQL, and a Tutorial.
Next
From: "Patrick Hatcher"
Date:
Subject: Is there a newer version of DBD::Pg?