Re: AW: Big 7.1 open items - Mailing list pgsql-hackers

From JanWieck@t-online.de (Jan Wieck)
Subject Re: AW: Big 7.1 open items
Date
Msg-id 200006152208.AAA12097@hot.jw.home
Whole thread Raw
In response to Re: AW: Big 7.1 open items  (Don Baccus <dhogaza@pacifier.com>)
Responses Re: AW: Big 7.1 open items  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Don Baccus wrote:
> At 10:04 AM 6/15/00 +0200, Zeugswetter Andreas SB wrote:
> >
> >This is not true. In my DBA history it would have saved me manweeks
> >of work if an easy and efficient restore of one single table from backup
> >would have been available in Informix and Oracle.
> >We allways had to restore most of the whole system to another machine only
> >to get back at some table info that would then be manually re-added
> >to the production system.
>
> I'm missing something, I guess.  You would do a createdb, do a filesystem
> copy of pg_log and one file into it, and then read data from the table
>  without having to restore the other tables in the database?
>
> I'm just curious - when was the last time you restored a Postgres
> database in this piecemeal manner, and how often do you do it?
   More  curios  to  me is that people seem to use physical file   based backup at all. Do they shutdown the
postmaster during   backup  or  do  they  live with the fact that maybe not every   backup is a vital one?
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Big 7.1 open items
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Big 7.1 open items