From: Tommy Gildseth <tommy.gildseth@usit.uio.no>
To: Chris Curvey <ccurvey@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: moving users/roles from one server to another?
Date: Wed, 10 Dec 2008 12:35:23 +0100
Message-ID: <493FA97B.90201@usit.uio.no> (raw)
In-Reply-To: <18c933b9-afe9-48af-849c-50eb6d3f87d8@c36g2000prc.googlegroups.com>
References: <18c933b9-afe9-48af-849c-50eb6d3f87d8@c36g2000prc.googlegroups.com>
Chris Curvey wrote:
> I'm a newbie to PG administration (although I have experience with
> other DBs). I need to move a single database to a brand new server.
>
> I've set up the new server with initdb, set up pg_hba.conf and
> postgresql.conf, and I can use dump and restore to move the database
> to the new environment.
>
> What I can't figure out is how to move all the existing users and
> roles over. I know about pg_dumpall, but that seems to be overkill --
> I don't need to move *all* the databases on my original server, just
> one of them.
>
> Is there a way to copy over just the users (with their passwords) and
> the roles?
>
>
pg_dumpall -g
If need be, you can edit the resulting SQL to only move over the bits
you need.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tommy.gildseth@usit.uio.no, ccurvey@gmail.com
Subject: Re: moving users/roles from one server to another?
In-Reply-To: <493FA97B.90201@usit.uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox