Re: Move passwords between databases

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

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

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

regards, tom lane