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

Hi.

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

----- Original Message -----
From: "John DeSoi" <desoi@pgedit.com>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-general@postgresql.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