Re: Issues Outstanding for Point In Time Recovery (PITR)

Richard Tucker wrote:
> 
> We also have implemented a roll forward recovery mechanism. We modified a
> 7.2.1 version of Postgres.
> The mechanism is designed to provide a means of recoverying from the loss or
> corruption of media.  It provides for duplicating wal_files so that if a
> wal_file is lost roll forward recovery can recover the database using the
> duplicated wal_files.  Hooks were also added so that the roll forward
> recovery mechanism can be used to implement a hot standby database.
> Along with the roll forward recovery mechanism we have also implemented an
> online database backup utility which is synchronized with the recovery log
> so that the backup can be a starting point for a roll forward recovery
> session.

In researching who has done this work, I found that
http://www.multera.com/ is Progress Software.  I assume this
"Distributed but Connected" is partly based on PostgreSQL.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026