[Babase] Fecal Questions for Jeanne

lacey.maryott at duke.edu lacey.maryott at duke.edu
Wed Jul 18 15:17:28 EDT 2007


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)

Thanks
Lacey


Quoting Jeanne Altmann <altj at princeton.edu>:

> Hi Lacey,
> I just caught Laurence by phone and since she has been having computer
> problems at home this week.  She says the tables are REPLACEMENT ones,
> NOT ones for appending; she has already appended new to old in what she
> sent.
>
> She will be back in tomorrow morning.
>
> Thanks,
> jeanne
>
> -----Original Message-----
> From: babase-bounces at eeblistserv.princeton.edu
> [mailto:babase-bounces at eeblistserv.princeton.edu] On Behalf Of
> lacey.maryott at duke.edu
> Sent: Wednesday, July 18, 2007 1:13 PM
> To: The Baboon Database Project
> Subject: [Babase] Fecal Questions for Jeanne
>
> Jeanne,
>   I just have a couple of questions for you before I can proceed with
> the fecal data.  Is this data a whole new set of data, to be added to
> what already exists in the tables within the Fecal Schema, or is it an
> updated duplicate of what is already there.  It appears that Tabby was
> assigning numbers to the table as she updated it, creating updated
> "versions" of the same data, as the tables are now called "tmprep2" and
> "tmpresults2"  Am I interpreting her nomenclature correctly, or is this
> a question for Tabby and Laurence?  I ask because all of the sids (I'm
> assuming this is a fecal sample id) are duplicated between the file I
> was sent and the current tmprep and tmpresults tables.
>
> Thanks
>
> Lacey
>
> _______________________________________________
> 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