pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmoving users/roles from one server to another?
3+ messages / 3 participants
[nested] [flat]
* moving users/roles from one server to another?
@ 2008-12-04 16:55 Chris Curvey <ccurvey@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Chris Curvey @ 2008-12-04 16:55 UTC (permalink / raw)
To: pgsql-admin
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: moving users/roles from one server to another?
@ 2008-12-10 11:35 Tommy Gildseth <tommy.gildseth@usit.uio.no>
parent: Chris Curvey <ccurvey@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tommy Gildseth @ 2008-12-10 11:35 UTC (permalink / raw)
To: Chris Curvey <ccurvey@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: moving users/roles from one server to another?
@ 2008-12-10 13:08 Marcelo Martins <pglists@zeroaccess.org>
parent: Chris Curvey <ccurvey@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Marcelo Martins @ 2008-12-10 13:08 UTC (permalink / raw)
To: Chris Curvey <ccurvey@gmail.com>; +Cc: pgsql-admin
pg_dumpall has a flag for globals only which dumps an SQL file with
that info. Check it out pg_dumpall --help
On Dec 4, 2008, at 10:55, Chris Curvey <ccurvey@gmail.com> 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?
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-12-10 13:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-04 16:55 moving users/roles from one server to another? Chris Curvey <ccurvey@gmail.com>
2008-12-10 11:35 ` Tommy Gildseth <tommy.gildseth@usit.uio.no>
2008-12-10 13:08 ` Marcelo Martins <pglists@zeroaccess.org>
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