pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Edward W. Rouse <erouse@comsquared.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: lost password
Date: Tue, 17 Nov 2009 18:56:46 -0500
Message-ID: <6762.1258502206@sss.pgh.pa.us> (raw)
In-Reply-To: <00c001ca67ce$fb3fd970$f1bf8c50$@com>
References: <00b501ca67cb$d8efd9e0$8acf8da0$@com>
	<00c001ca67ce$fb3fd970$f1bf8c50$@com>

"Edward W. Rouse" <erouse@comsquared.com> writes:
> After I copied the md5 over I played around a bit and found the for the
> process user. I then used the alter user sql statement and rechecked the
> md5. It was different, but I could still use the same password to log in.
> Needless to say, I am a bit confused by that, but it works and that's what I
> need.

The md5 will depend on both the actual password and the user's name
... does that help?

			regards, tom lane



view thread (4+ messages)  latest in thread

Message-ID: <6762.1258502206@sss.pgh.pa.us>
Permalink:  ../6762.1258502206@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/6762.1258502206@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, erouse@comsquared.com
  Subject: Re: lost password
  In-Reply-To: <6762.1258502206@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox