Search Postgresql Archives

Re: Dump/restore with bad data and large objects

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
>
>




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux