2009 6:57 PM
To: Edward W. Rouse
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] lost password
"Edward W. Rouse" 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. I
"Edward W. Rouse" 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,
Well I quickly found out 2 things:
1. You can copy the md5 over and have it work
2. The same password can have different md5's
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. I