Re: Database users Passwords - Mailing list pgsql-general

From Jeff Davis
Subject Re: Database users Passwords
Date
Msg-id 1161107681.31645.142.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: Database users Passwords  ("DEV" <dev@umpa-us.com>)
List pgsql-general
On Tue, 2006-10-17 at 12:54 -0400, DEV wrote:
> Okay but the issue I have is that I have the passwords already generated and
> in crypt() format and would love to just use them if at all possible?
>

PostgreSQL won't doesn't recognize crypt passwords, as far as I know.
That means that it's pretty much impossible.

Use a password recovery tool to get the plain text back, and encrypt it
using md5.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Alexandre Arruda
Date:
Subject: Re: pg_locks: who is locking ? (SOLVED!)
Next
From: Vivek Khera
Date:
Subject: Re: Fast backup/restore