Re: Move passwords between databases

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

Tom> Raj Mathur <raju(at)linux-delhi(dot)org> writes:
>> mdu=# alter user raju with encrypted password 'raju'; ALTER
>> USER mdu=# select passwd from pg_shadow where usename='raju';
>> passwd
>> -------------------------------------
>> md5ef70c430d5ed1ed52bd2ae960bb8ebe4 (1 row)

>> mdu=# create user xxx with password
>> 'md5ef70c430d5ed1ed52bd2ae960bb8ebe4'; CREATE USER

Tom> That's not going to work, because the user name is included
Tom> into the password encryption algorithm, so two different
Tom> usernames with the same cleartext password are going to have
Tom> two different encrypted passwords. (This is a feature, not a
Tom> bug.)

Oooh, that's what I was missing then.

Tom> You can transfer the same usernames with the same passwords
Tom> from one system to another using the method shown above. You
Tom> cannot assign one user's password to another username this
Tom> way.

Great, it works now.

Thanks! Both PostgreSQL and you guys rock!

Regards,

-- Raju
--
Raj Mathur raju(at)kandalaya(dot)org http://kandalaya.org/
GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F
It is the mind that moves