From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Another PITR question |
Date: | 2004-07-31 18:12:03 |
Message-ID: | Pine.UW2.4.53.0407312005390.27536@server.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2004-07-31 18:20:53 | Re: plpgsql compile error on win32 |
Previous Message | Tom Lane | 2004-07-31 17:49:44 | Re: plpgsql compile error on win32 |