Thread: AW: AW: Big 7.1 open items

AW: AW: Big 7.1 open items

From
Zeugswetter Andreas SB
Date:
> >> 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?

No if you want to restore to a separate postgres instance you need to 
restore all pg system tables as well.
What I meant is create a new table in your production server and replace 
the new 0 byte file with your backup file (rename it accordingly).

Andreas