Re: [SQL] lost password

2009-11-18 Thread Edward W. Rouse
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

Re: [SQL] lost password

2009-11-17 Thread Tom Lane
"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,

Re: [SQL] lost password

2009-11-17 Thread Edward W. Rouse
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