I've started scanning through the 6.0 backend code, and there has to be an
easier way... It might take me a week before I could hack the code and
get it working... Unless somebody could tell me which function in which
file needs to return what...
Thanks for the advice... I'm still digging through the code, but if
there's an easier way, i'd appreicate knowing....
Thanks,
Justin
On Mon, 29 Mar 1999, Bruce Momjian wrote:
> > I had a server crash and it seems that I have all the data recovered
> > except the pg_log file. I am running an older version of postgres
> > (6.0) and I want to know if there is a way to rebuild the pg_log and the
> > pg_time file from the data that is contain in the data/base/DBName
> > directory???
> >
> > I have a backup copy of pg_log, but it is a month old, and when I use
> > that, I only have access to the data up until that date.
> >
> > Can this be done or am I going to have to recreate all the data since
> > the last pg_log backup??
> >
>
> pg_log only has bit stamps for committed transactions. If you can
> assume all your transactions were committed, you may be able to hack the
> backend code so all lookups to pg_log return a committed transaction
> value.
>
> --
> Bruce Momjian | http://www.op.net/~candle
> [EMAIL PROTECTED] | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>