[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