Re: AW: more corruption

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim Perdue <tperdue(at)valinux(dot)com>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: AW: more corruption
Date: 2000-07-10 15:17:46
Message-ID: 747.963242266@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tim Perdue <tperdue(at)valinux(dot)com> writes:
>>>>>> -now hopefully I can create my indexes and be back in business

> I vacuumed here and it worked. I did not use my "old" pg_log file - what
> did I lose?

Hard to tell. Any tuples that weren't already marked on disk as "known
committed" have probably gone missing, because their originating
transaction IDs likely won't be shown as committed in the new pg_log.
So I'd look for missing tuples from recent transactions in the old DB.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-07-10 15:28:48 Re: memory: bug or feature
Previous Message Tom Lane 2000-07-10 15:14:55 Re: Re: postgres TODO