Another PITR question - Mailing list pgsql-hackers

From ohp@pyrenet.fr
Subject Another PITR question
Date
Msg-id Pine.UW2.4.53.0407312005390.27536@server.pyrenet.fr
Whole thread Raw
List pgsql-hackers
Hi all,

I have another PITR question on  my mind:
As I see it, PITR has 2 functions:
1 is to recover a disaster like a disk crash. Change the disk, restore
PGDATA and play the logs back that'fine.
2 Junior DBA  (or customer) says "ch..;  I droped the wrong table..."
In that case, restoring PGDATA restores the whole cluster. Is there a way
just to restore $PGDATA/base/<datoid>?

Or did I miss something.

I'm testing 7.5dev on unixware and I'm impressed by how fast it gets.
Although creating integer indexes *SEEMS* a bit slow but it's out of
topic.

Thanks for the great work!

-- 
Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql compile error on win32
Next
From: "Magnus Hagander"
Date:
Subject: Re: plpgsql compile error on win32