Re: user groups

Hi.

Thank you for information. How can I dump_all from pgAdmin III ?
Thanks.

----- Original Message -----
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>
Sent: Wednesday, June 15, 2005 1:25 AM
Subject: Re: [GENERAL] user groups

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org