[Babase] Fecal Questions for Jeanne
Karl O. Pinc
kop at meme.com
Wed Jul 18 21:20:37 EDT 2007
On 07/18/2007 07:49:13 PM, lacey.maryott at duke.edu wrote:
>
> Quoting "Karl O. Pinc" <kop at meme.com>:
>
>>
>> On 07/18/2007 02:17:28 PM, lacey.maryott at duke.edu wrote:
>>> Ok, I'm going to go ahead and create a backup of the fecal schema,
>>> empty it,
>>> restore it? (right?) to make sure restore works, empty it again and
>>> then insert
>>> the updated data.
>> But I was thinking you'd restore it somewhere else just so
>> you'd keep the data you already have in case there's a problem.
> Ok, where would be a good place to stick it? I'm guessing this data
> has no
> validation, since it is just in its own schema at this point, so would
> restoring it into my schema work?
Nothing wrong with restoring it into your scheama.
(Whatever validation it does have, via constraints,
I'd expect to restore with the file if you have the
restore command re-create the file and not just the data.
See CREATE TABLE for info on constraints.
I'd not expect it to have any triggers and
supporting functions.)
(If you felt like it you could read the pg docs and
use the babase_admin account to make another schema.
Or read "less usr/local/bin/babase-user-add" for an example
of how to make a schema.)
Oh and by the by... did I really
> get that
> command right on the first try??? hahaha if so I never fail to amaze
> myself!
Well, look at it this way. I've not tried your restore
command either so there's no telling. :-)
(But congradulations regardless!)
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