Orr, Steve wrote: > Newbie here... > > How do I restore data changes made after the backup? I've been combing the > docs and the web site but I don't see anything on this. Given a backup taken > this morning, and a failure requiring a database restore, how do I restroe > the data that was added after the backup was taken this morning? Isn't there > any log files to apply to pg_restore? Does PostgreSQL have the ability to > restore to the point of failure so no transactions are lost? (Like Oracle?) > Is replication commonly used for this?
You want point-in-time recovery. That is for 7.4. That should be a 6 months away. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
