On Tuesday 31 March 2009 6:44:52 am Reid Thompson wrote: > I've a DB and I want to migrate the users to a new empty DB. How do I > dump/reload just the users? > > Thanks, > reid pg_dumpall -g From: http://www.postgresql.org/docs/8.3/interactive/app-pg-dumpall.html -g --globals-only Dump only global objects (roles and tablespaces), no databases. -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general