> > > > > -currently vacuuming the new db - nothing is barfing yet
> >
> > Actually, the vacuum seemed to be running forever making no
> > progress so
> > I killed it.
> >
> > > > > -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?
>
> Tuples that have been inserted/updated/deleted after last vacuum
> in old db assume that the corresponding txn has to be rolled back.
Correction: Tuples that have been inserted/updated/deleted but have not
been accessed afterwards (the magic first access that updates the tuple
transaction status inplace).
> Since your vacuum on old db only did half the db, that half
> will be current,
> but the rest will be old, thus you loose consistency.
>
> One of the core please confirm.
Andreas