Re: Move passwords between databases

Raj Mathur <raju@linux-delhi.org> writes:
> Using Postgresql 7.2.3 on Linux, is there an easy way to transfer user
> passwords from one database to another?

You could look at what pg_dumpall --globals-only does.

> 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.

AFAIK you can just do it.  The CREATE or ALTER USER command should
recognize the password as already encrypted and not munge it.  Are
you sure you are using the correct pg_hba.conf setup on the destination
system?

            regards, tom lane