Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37024=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1Tsan2-00035v-Uq
	for pgsql-sql@arkaria.postgresql.org; Tue, 08 Jan 2013 15:08:33 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37024=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1Tsan1-00058Y-VI
	for pgsql-sql@arkaria.postgresql.org; Tue, 08 Jan 2013 15:08:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <erouse@comsquared.com>) id 1Tsan1-00058S-3K
	for pgsql-sql@postgresql.org; Tue, 08 Jan 2013 15:08:31 +0000
Received: from smtp.comsquared.com ([209.155.237.140])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <erouse@comsquared.com>) id 1Tsamy-0007iR-Q6
	for pgsql-sql@postgresql.org; Tue, 08 Jan 2013 15:08:30 +0000
Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1])
	by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id
	r08F8GwV015450
	for <pgsql-sql@postgresql.org>; Tue, 8 Jan 2013 10:08:20 -0500 (EST)
Received: from erouse052008 ([10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	r08F8Lfx025108
	for <pgsql-sql@postgresql.org>; Tue, 8 Jan 2013 10:08:21 -0500 (EST)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: <pgsql-sql@postgresql.org>
Subject: copy users/groups
Date: Tue, 8 Jan 2013 10:08:21 -0500
Message-ID: <021a01cdedb1$ff7340b0$fe59c210$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: Ac3tsf8bsrfX6tNcSa61p8dU5DOuKA==
Content-Language: en-us
X-Pg-Spam-Score: 0.8 (/)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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?


Edward W. Rouse



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