Re: pg_dump and roles

From: Yauheni Labko <yyl(at)chappy(dot)com>
To: Julie Warden <Julie_Warden(at)nospam(dot)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump and roles
Date: 2008-10-03 20:12:13
Message-ID: alpine.DEB.2.00.0810031610190.2149@tech-pc04.chappy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> Is there a method to dump just the roles from a database, or otherwise
> select them, so I can build a script to reload the roles? Otherwise, I
> guess I'll just read the tables for each database and build the
> security script from that.

from man pg_dumpall:

-r

--roles-only
Dump only roles, no databases or tablespaces.

Eugene

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Fromm 2008-10-03 22:16:11 logging
Previous Message Peter Steinheuser 2008-10-03 17:44:13 Re: pg_dump and roles