Search Postgresql Archives

Re: how can i migrate just the users from one db to a new one

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux