| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: user groups |
| Date: | 2005-06-14 23:25:31 |
| Message-ID: | 1682407fa97167b715146c04b00e2e10@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jun 14, 2005, at 6:17 PM, Zlatko Matić wrote:
> When I create some user group and set permissions and then dump
> (backup) database and install on some other computer, what will happen
> with groups and permissions? Should they exist on other computers too
> ?
> I don't understand whether permissions to groups are something that
> is integrated in the database or it is just attached to database ?
> Greetings,
If you use pg_dumpall, then all the user and group information will be
included in the backup file. See
http://www.postgresql.org/docs/8.0/interactive/app-pg-dumpall.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve - DND | 2005-06-14 23:32:58 | Current transaction ID? |
| Previous Message | Pailloncy Jean-Gerard | 2005-06-14 22:51:33 | Bad pg_xlog with no redo |