On Fri, Jul 1, 2011 at 5:06 AM, salah jubeh <s_jubeh@xxxxxxxxx> wrote: > > Hello, > > I have two databases, I need to insure that both databases has the same > roles. tables, schemas, views must have the same permissions and > privileges. you can say and Identical clones. I can synchronize the roles > using these statements I guess it kinda depends on what you are trying to do. If these are db's on the same db cluster, then no action is necessary since roles are shared among databases. If they are on different clusters and servers, I think your approach will fail to synchronize passwords if those are required. I would probably do a pg_dumpall -s and use grep to pullout the create/alter role statements along with grants. Best wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
