how can i migrate just the users from one db to a new one
Started by Reid Thompsonabout 17 years ago2 messagesgeneral
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
Re: how can i migrate just the users from one db to a new one
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@comcast.net