Re: User table porting

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: User table porting
From: Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx>
Date: Tue, 10 Mar 2009 11:23:01 -0600
In-reply-to: <1178C89D-62DF-44AA-A8CB-97FA782E869D@xxxxxxxxxxx>
Organization: Consistent State
References: <1178C89D-62DF-44AA-A8CB-97FA782E869D@xxxxxxxxxxx>
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx
User-agent: KMail/1.11.0 (Linux/2.6.27.19-170.2.35.fc10.x86_64; KDE/4.2.0; x86_64; ; )

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>

Follow-Ups:
- Re: User table porting
  - From: Jan-Peter Seifert

References:
- User table porting
  - From: Carol Walter

Prev by Date: User table porting
Next by Date: Re: User table porting
Previous by thread: User table porting
Next by thread: Re: User table porting
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux