Re: Log File?

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?
>
> http://www.postgresql.org/search.mpl
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026