Re: User table porting

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: User table porting
Date: 2009-03-10 17:23:01
Message-ID: 200903101123.01310.kevink@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-03-10 17:31:56 Re: User table porting
Previous Message Carol Walter 2009-03-10 17:13:54 User table porting