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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
