THANKS! for the quick answer. Yes I want point in time recovery and I can wait 6 months. $64K question... Will it be delivered on schedule? ;-)
I also want replication. Any other info other than what on the web site? Anyone used eRServer? Is the Postgres-R project a separate endeavor? Is there a schedule for production release? Where can I find out more? THANKS! -----Original Message----- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 4:16 PM To: Orr, Steve Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] How do I restore data changes made after the backup? 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
