Another PITR question
От | ohp@pyrenet.fr |
---|---|
Тема | Another PITR question |
Дата | |
Msg-id | Pine.UW2.4.53.0407312005390.27536@server.pyrenet.fr обсуждение исходный текст |
Список | 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 по дате отправления: