> 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
