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@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
