Skip site navigation (1) Skip section navigation (2)

How do I restore data changes made after the backup?

From: "Orr, Steve" <sorr(at)rightnow(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How do I restore data changes made after the backup?
Date: 2002-09-17 22:00:30
Message-ID: D408B6AC060DB24790622E1A54204DB00823AD26@xchange.rightnowtech.com (view raw or flat)
Thread:
Lists: pgsql-admin
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? 


Please advise,
Steve Orr

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2002-09-17 22:16:02
Subject: Re: How do I restore data changes made after the backup?
Previous:From: Andreas SchlegelDate: 2002-09-17 21:28:54
Subject: URGENT: pg_restore problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group