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