Move passwords between databases

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(at)kandalaya(dot)org http://kandalaya.org/
GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F
It is the mind that moves