> 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?
Oops, guess I answered wrong. We don't have a transaction log mechanism
to preserve logs between backups. Some people have explored the idea,
but we have not gotten a solution yet.
--
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