[Babase] Fecal Questions for Jeanne
lacey.maryott at duke.edu
lacey.maryott at duke.edu
Wed Jul 18 20:49:13 EDT 2007
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!
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
>
More information about the Babase
mailing list