Re: PITR question

ohp@pyrenet.fr wrote:
> 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...

Was this corrected?  I don't see any followups to it in the archives.

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

No, there is no way to restore just one database to an earlier time than
the others.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073