On Mon, 25 Aug 2008 17:05:53 -0400 "John T. Dow" <john@xxxxxxxxxxxx> wrote: > Joshua > > Thank you very much for answering these various questions. > > I guess the compressed format is the best overall solution, except > for roles. I find myself having a table with other information about > users (application specific user type, etc) so perhaps the thing to > do is record enough information there to reconstruct the roles should > that become necessary. > > Can pg_dump dump roles to plain text? How does pg_dumpall do it, pg_dumpall -g will dump just roles via plain text. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
