Re: How to export users?

From: "Marc Mitchell" <marcm(at)eisolution(dot)com>
To: "'Chris Hoover'" <revoohc(at)sermonaudio(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to export users?
Date: 2004-06-07 17:09:36
Message-ID: 00cb01c44cb2$366b7c40$6c01050a@MarcM8500
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Try "pg_dumpall -g".

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

Good luck.

Marc Mitchell - Transportation Practice Director
Enterprise Information Solutions
Downers Grove, IL 60515
marcm(at)eisolution(dot)com

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Chris Hoover
Sent: Monday, June 07, 2004 10:48 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] How to export users?

I am having a bit of a problem with getting my users to a new server.
Does anyone know a quck way to export the user list from one server to
import into a new server?

Thanks,

Chris

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marek Dąbrowski 2004-06-07 17:31:02 Growing number of postmaster processes
Previous Message Jeff Self 2004-06-07 16:57:01 Re: Mac OS 10.3.4: pgsql fails to launch at boot