I am cleaning up an old 6.5 postgres installation prior to migrating it over
to 7.0.3. Looking in pg_class, I see some tables named pg_temp.<PID>.1 thru
7. I assume these were temp tables that got left behind when a backend with
pid <PID> died. Is it safe to delete these rows from pg_class? What else
should I do to clean up before migrating everything to 7.0.3?
I also see old pg_temp* and pg_sorttemp* in the data directory. I guess I'll
be deleting those too.
Brian