Log File?
Our company is deciding whether to choose Postgresql or not and
have a question. Say we back up our database every night and the
next day at 11am, the hard drive crashes. We then have data from
our back up from last night, but, is there a way to have a log file sitting
somewhere
other than the hard drive that will allow us to retrieve all data
from that morning and add that data to the back up? Therefore, we
will have only lost the trasaction that we would have been working
on because it has not been commited. Any answer would be extremely helpful.
You are asking for point-in-time recovery. That should be in 7.2.
Our company is deciding whether to choose Postgresql or not and
have a question. Say we back up our database every night and the
next day at 11am, the hard drive crashes. We then have data from
our back up from last night, but, is there a way to have a log file sitting
somewhere
other than the hard drive that will allow us to retrieve all data
from that morning and add that data to the back up? Therefore, we
will have only lost the trasaction that we would have been working
on because it has not been commited. Any answer would be extremely helpful.---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026