> I've installed PostgreSQL on a development machine and I'm trying to
> convince my company to migrate applications to it. The biggest question
> I've had is:
>
> "How do you recover the database? After a snapshot is restored from
> archive can you use the transaction log to roll it forward?"
>
> The section on database recovery is unfinished in the 6.4 manual. Can
> anyone offer any advice or references?
Just restore and start the postmaster. Our system does not use
transaction logs like other systems. Our transaction log is inside
every table, and you need to use vacuum every so often to clear out the
superceeded transactions.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
