[Babase] Fecal Questions for Jeanne
lacey.maryott at duke.edu
lacey.maryott at duke.edu
Wed Jul 18 21:11:34 EDT 2007
Quoting lacey.maryott at duke.edu:
>
> 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. Karl is this what you had in mind?
>>>
>>> also, for the restore am I using something like:
>>>
>>> $ pg_restore --file fecalbackup.custom --host=localhost --schema=fecal
>>> --data-only --user lmaryott babase
>>>
>>> This is a combination of what i found in the Postgres documentation,
>>> and the
>>> backup documentation on the Wiki... (Probably a less than accurate
>>> procedure..
>>> but a first shot anyway)
>>
>> That all sounds good.
>>
>> 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.
>>
>> (If you don't use --data-only on the backup then the restore
>> will re-create the file for you.)
>>
>
> 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? 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!
>
This is why I shouldn't work at night, hahaha... I can't restore a
schema into a
schema, can I? This just occurred to me as I sat here thinking about
what to do
next. Karl, could we maybe have a phone call tomorrow? I'm just needing to
clarify a few things I think. Thanks :)
> Lacey
>
>> Karl <kop at meme.com>
>> Free Software: "You don't pay back, you pay forward."
>> -- Robert A. Heinlein
>>
>> _______________________________________________
>> Babase mailing list
>> Babase at www.eco.princeton.edu
>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>
>
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>
More information about the Babase
mailing list