Hi,
Using Postgresql 7.2.3 on Linux, is there an easy way to transfer user
passwords from one database to another?
I have an application that creates data (and users) centrally and then
distributes them to remote databases. I can transfer everything else,
but do not know how to transfer MD5 passwords.
As a last resort the application could store the passwords in
plain-text in the central database and then use a remote "alter user
with encrypted password..." command to update the user's password, but
I'd rather avoid that if there is any alternative available.
I tried an "update pg_shadow set passwd=... where usename=..."
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
