[Babase] Fecal Update
Laurence
lgesquie at princeton.edu
Thu Jul 19 15:52:17 EDT 2007
Thanks a lot Lacey and Karl!
Laurence
Lacey Maryott wrote:
> Hello All,
> Karl and I just spent roughly 90 minutes figuring out the commands
> together (and Karl teaching me how to do things), but we are at the
> stage where I can go ahead and put the new data into the fecal
> tables. The only hold up now is that, as I pointed out earlier today
> in an e-mail to the list, the export and import buttons have
> disappeared from this newest version of PPA. Karl is working on the
> issue as I write this e-mail and hopes to have it resolved soon at
> which point I will put the new data into tmprep2 and tmpresults. For
> right now, these tables are unusable, as this transition happens (you
> could use them, but don't trust them) But as soon as the most updated
> information is in these tables, I will let everyone know! :) This
> should be completed by days end! :)
>
> Lacey
>
> Laurence wrote:
>> 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
>>
>> _______________________________________________
>> 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/947732ac/lgesquie.vcf
More information about the Babase
mailing list