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
