[Babase] Fecal Questions for Jeanne

Karl O. Pinc kop at meme.com
Wed Jul 18 16:31:04 EDT 2007


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.)

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list