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 [EMAIL PROTECTED] http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F It is the mind that moves ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
