PITR question

From: ohp(at)pyrenet(dot)fr
To: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: PITR question
Date: 2004-08-19 12:51:28
Message-ID: Pine.UW2.4.53.0408191441120.10064@server.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Every one.

At least I made PITR working however I still have 2 questions:

1) It seems there is a slight bug in this case:
select pg_backup_start('test);
... make backup
select pg_backup_end();
psql database
drp table.... note the time in logs
pg_ctl stop
rm -rf $PGDATA
restore backup
put the timestamp in recovery.conf and recover_inclusive=false
pg_ctl start

... you end up with a core dump (signal 6) and an error saying that you
can't stop before end of backup.

This is because it's the FIRST transaction after backup and ending restore
BEFORE this means ending before the end of backup...

2)

How do I restore EVERY database to the end of logs BUT one?
Same case here:
I wrongly droped a table so I restart and end the recovery before the drop
but I still want all the other DB in the cluster to go to the end of logs.
I ass/u/me I cant restore just the DB dir??

Many thanks for any explanation.

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard van den Berg 2004-08-19 13:32:32 Added schema selection to pg_restore
Previous Message Andrew Dunstan 2004-08-19 11:21:29 Re: PGPASSWORD and client tools