In Oracle i know that there is a option of resetting the logs if we have to restore some time in back, not sure how it works in new Postgres 8.
Morus Walter wrote:
Pallav Kalva writes:
If I want to restore to a particular point in time lets say to the point in time like a day back when one of my table was dropped accidentally and if i want restore the archive log only to that particular archive log file . what is the procedure we should follow ? just keep the archive logs in the directory until the last archive log file i need or is there a command something like " restore only until at this archive log file " ? Also what happens to the transaction log files in pg_xlog directory in this scenario ? do i have to still keep them or they get created by themself since i am going a day back ?
Is this possible in postgres 8
Yes. That's what PITR is about. Read the manual for details. If you look at the recovery.conf.sample you'll find a variable recovery_target_time that must be set. Unless I missed something this isn't explicitly stated in the docs but the comment in the sample conf is pretty clear. Alternatively you can define a transaction id (recovery_target_xid).
Of course you must have a backup created before the incident and all WALs up to the time of the incident.
Morus
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
