Re: Database users Passwords

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: DEV <dev(at)umpa-us(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database users Passwords
Date: 2006-10-17 17:54:41
Message-ID: 1161107681.31645.142.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs 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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Shane Ambler 2006-10-17 18:09:02 Re: Database users Passwords
Previous Message DEV 2006-10-17 16:54:51 Re: Database users Passwords

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2006-10-17 17:58:34 Re: Fast backup/restore
Previous Message AgentM 2006-10-17 17:43:04 Re: A query planner that learns