On Tuesday 10 March 2009 11:13:54 Carol Walter wrote: > I want to recreate users with their passwords from one database > cluster on another database cluster. What would be the best way for > me to do this? > > Thanks, > Carol
from the "old" server run this (where <new_db_cluster> is the new server): pg_dumpall -g | psql -h <new_db_cluster>