pg_temp.. - Mailing list pgsql-general

From Brian Baquiran
Subject pg_temp..
Date
Msg-id 04fd01c0ac39$d07d7490$4e64a8c0@edsamail.com
Whole thread Raw
Responses Re: pg_temp..  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Jan Ploski
Date:
Subject: Is v7.1 stable enough?
Next
From: "keith"
Date:
Subject: Fw: Please Help