Re: Move passwords between databases

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

    Tom> Raj Mathur <raju@linux-delhi.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@kandalaya.org      http://kandalaya.org/
       GPG: 78D4 FC67 367F 40E2 0DD5  0FEF C968 D0EF CC68 D17F
                      It is the mind that moves