On Tue, Feb 01, 2005 at 12:11:06AM -0700, Pritesh Shah wrote: > > Is there any way of copying/dumping/restoring the user and group > information and permissions from the old machine to the new one so > that i do not have to do a createuser everytime??
You can dump just users and groups with "pg_dumpall --globals-only" (or -g). -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org