Does this mean that if I performed a pg_dump at 8:00 AM, performed some
updates, inserts and deletes at 10:00AM, destroyed and restored my database
at 12:00 noon using the 8:00AM pg_dump that all of the insert, updates, and
deletes that I did at 10:00 AM would still exist in the newly restored
database?
-----Original Message-----
From: Bruce Momjian [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 22, 1999 7:29 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Recovery from the transaction log?
> 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
