At 10:04 AM 6/15/00 +0200, Zeugswetter Andreas SB wrote:
>
>> In reality, very few people are going to be interested in restoring
>> a table in a way that breaks referential integrity and other 
>> normal assumptions about what exists in the database. 
>
>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?



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.

Thu, 15 Jun 2000 05:40:49 -0700
Don Baccus <dhogaza@pacifier.com>
Re: AW: Big 7.1 open items
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 #



Fri, 16 Jun 2000 00:08:16 +0200 (MEST)
JanWieck@t-online.de (Jan Wieck)
Re: AW: Big 7.1 open items
> > 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?

I sure hope they shut down the postmaster, or know that nothing is
happening during the backup.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 15 Jun 2000 19:11:34 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: AW: Big 7.1 open items
On Thu, 15 Jun 2000, Bruce Momjian wrote:

> > > 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?
> 
> I sure hope they shut down the postmaster, or know that nothing is
> happening during the backup.

I do a backup based on a pg_dump snapshot at the time of the backup
... 



Fri, 16 Jun 2000 13:58:03 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: AW: Big 7.1 open items