Re: pg_dump and roles - Mailing list pgsql-admin

From Yauheni Labko
Subject Re: pg_dump and roles
Date
Msg-id alpine.DEB.2.00.0810031610190.2149@tech-pc04.chappy.com
Whole thread Raw
In response to pg_dump and roles  (Julie Warden <Julie_Warden@nospam.hotmail.com>)
List 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

pgsql-admin by date:

Previous
From: "Peter Steinheuser"
Date:
Subject: Re: pg_dump and roles
Next
From: Marc Fromm
Date:
Subject: logging