| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | "Edward W(dot) Rouse" <erouse(at)comsquared(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: copy users/groups |
| Date: | 2013-01-08 15:25:25 |
| Message-ID: | 50EC3A65.6080203@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 01/08/2013 07:08 AM, Edward W. Rouse wrote:
> We have a database that was updated from 7.4.1 to 9.1.3. I've gotten
> everything working, but now it seems that the users and groups weren't
> restored. Probably because they weren't backed up. Is there a way to dump
> just the users and groups, plus the passwords and permissions, and restore
> them without overwriting what's been manually added to the new database?
Users/groups i.e roles are global to a cluster, you need to use pg_dumpall:
http://www.postgresql.org/docs/9.1/interactive/app-pg-dumpall.html
pg_dumpall -g
Will dump only the global items.
>
>
> Edward W. Rouse
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emi Lu | 2013-01-08 21:53:56 | How to generate drop cascade with pg_dump |
| Previous Message | Edward W. Rouse | 2013-01-08 15:08:21 | copy users/groups |