Message-ID: <50EC3A65.6080203@gmail.com>
Date: Tue, 08 Jan 2013 07:25:25 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: "Edward W. Rouse" <erouse@comsquared.com>
CC: pgsql-sql@postgresql.org
Subject: Re: copy users/groups
References: <021a01cdedb1$ff7340b0$fe59c210$@com>
In-Reply-To: <021a01cdedb1$ff7340b0$fe59c210$@com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 01/08/2013 07:08 AM, Edward W. Rouse wrote:
> We have a database that was updated from 7.4.1 to 9.1.3. I've gotten
> everything working, but now it seems that the users and groups weren't
> restored. Probably because they weren't backed up. Is there a way to dump
> just the users and groups, plus the passwords and permissions, and restore
> them without overwriting what's been manually added to the new database?

Users/groups i.e roles are global to a cluster, you need to use pg_dumpall:

http://www.postgresql.org/docs/9.1/interactive/app-pg-dumpall.html

pg_dumpall -g

Will dump only the global items.

>
>
> Edward W. Rouse
>
>
>


-- 
Adrian Klaver
adrian.klaver@gmail.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql