Skip site navigation (1) Skip section navigation (2)

Re: moving users/roles from one server to another?

From: Marcelo Martins <pglists(at)zeroaccess(dot)org>
To: Chris Curvey <ccurvey(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: moving users/roles from one server to another?
Date: 2008-12-10 13:08:19
Message-ID: 377DA777-0632-4EE0-9ED8-8F7D13A82CC5@zeroaccess.org (view raw or flat)
Thread:
Lists: 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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-12-10 14:15:26
Subject: Re: File system level backup with more than one cluster folders
Previous:From: zz_11Date: 2008-12-10 12:23:35
Subject: warm standby server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group