[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