[Babase] Re: Dump and restore
Karl O. Pinc
kop at meme.com
Tue Feb 12 11:07:06 EST 2008
On 02/12/2008 08:25:26 AM, kfenn wrote:
> Hi Lacey and Karl,
>
> Here is my first pass at a detailed protocol for doing an dump and
> restore of a schema.
> Lacey, can you try it and add any additional
> instuctions/clarifications you think would be helpful...? I think
> the goal should be to have a document that we can hand to a new
> database manager which they can follow immediately...in other words,
> no gaps in the instructions or assumptions about knowledge of Unix or
> Babase2 (other than knowing how to log in and navigate to an SQL
> window in PPA).
I might include the "how to login to papio with ssh" as a separate
document, seeing as how it's pretty much independent and it seems
to me that you might need to do that for other reasons.
(*sigh* Just a wee bit more work and I could have written you
a web program to do all this.)
You might want a link to the postgresql pg_dump and pg_restore
documentation pages.
>
> I have one question for Karl....
> In Step 2 how does the computer know that we want the Babase schema
> from the Babase database and not from babase_test? There doesn't
> seem to be any command language to specify this.
The last word on the command line is the name of the database.
So you'd say babase_test instead of "babase" if you wanted to
dump from the babase test database.
How would I dump
> from babase test if I wanted to do a comparison of files or something?
You'd want to use --format=p instead of --format=c so as
to get SQL. Then you could compare it, read it etc.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list