Re: AW: more corruption

Zeugswetter Andreas SB wrote:
> > > -I created a new db
> > > -used the old db schema to create all new blank tables
>
> vacuum new db
> (I would do a tar backup of the whole old db)
> vacuum old db, if that is possible

Was not possible.

> > > -copied the physical table files from the old data
> > directory into the
> > > new database directory
>
> if above vacuum old db was not possible copy old pg_log

Oops - I didn't do that.

> > > -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?

Tim

--
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723