Sorry, I missed that. Thanks again. Now to put this all into effect. John On Mon, 25 Aug 2008 14:25:12 -0700, Joshua Drake wrote: >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 > >