Skip site navigation (1) Skip section navigation (2)

Re: Dump/restore with bad data and large objects

From: Joshua Drake <jd(at)commandprompt(dot)com>
To: "John T(dot) Dow" <john(at)johntdow(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dump/restore with bad data and large objects
Date: 2008-08-25 21:25:12
Message-ID: 20080825142512.5eeb86b5@jd-laptop (view raw or flat)
Thread:
Lists: pgsql-general
On Mon, 25 Aug 2008 17:05:53 -0400
"John T. Dow" <john(at)johntdow(dot)com> 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



In response to

Responses

pgsql-general by date

Next:From: John T. DowDate: 2008-08-25 21:27:26
Subject: Re: Dump/restore with bad data and large objects
Previous:From: John T. DowDate: 2008-08-25 21:05:53
Subject: Re: Dump/restore with bad data and large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group