Thanks, it worked. On Tue, 1 Feb 2005 00:30:31 -0700, Michael Fuhr <mike@xxxxxxxx> wrote: > 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 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
