[Babase] Fecal Questions for Jeanne
Laurence
lgesquie at princeton.edu
Thu Jul 19 12:16:44 EDT 2007
Hello Lacey,
Thanks so much for taking care of the fecal tables for me. Let me know
if you have any questions or if I can help you in any way.
Laurence
lacey.maryott at duke.edu wrote:
> 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
>>
>
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lgesquie.vcf
Type: text/x-vcard
Size: 314 bytes
Desc: not available
Url : http://www.eco.princeton.edu/pipermail/babase/attachments/20070719/b6d211ad/lgesquie.vcf
More information about the Babase
mailing list