Postgres Pro
Downloads
Home   >   mailing lists

Re: User table porting - Mailing list pgsql-admin

From Kevin Kempter
Subject Re: User table porting
Date
Msg-id 200903101123.01310.kevink@consistentstate.com
Whole thread Raw
In response to User table porting  (Carol Walter <walterc@indiana.edu>)
Responses Re: User table porting  (Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>)
List pgsql-admin
Tree view
On Tuesday 10 March 2009 11:13:54 Carol Walter wrote:
> I want to recreate users with their passwords from one database
> cluster on another database cluster. What would be the best way for
> me to do this?
>
> Thanks,
> Carol


from the "old" server run this (where <new_db_cluster> is the new server):


pg_dumpall -g | psql -h <new_db_cluster>

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: User table porting
Next
From: Tom Lane
Date:
Subject: Re: User table porting